start page | rating of books | rating of authors | reviews | copyrights

CD Home

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Index: L

LAN: 1.1. The Internet Grows Up, Oracle Web Applications
LAST function
10.8.2. PL/SQL Table Built-ins, Oracle PL/SQL Programming
10.8.2.5. The LAST function, Oracle PL/SQL Programming
19.6.5. FIRST, LAST, Oracle PL/SQL Programming
LAST_DAY function: 12.1.2. The LAST_DAY function, Oracle PL/SQL Programming
LAST_ERROR_POSITION function
2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.10.1. The DBMS_SQL.LAST_ERROR_POSITION function, Oracle Built-in Packages
C.14.10. The LAST_ERROR_POSITION function, Oracle PL/SQL Programming
SQLERRM and: 2.3.10.1. The DBMS_SQL.LAST_ERROR_POSITION function, Oracle Built-in Packages
LAST_ROW_COUNT function
2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.10.2. The DBMS_SQL.LAST_ROW_COUNT function, Oracle Built-in Packages
C.14.11. The LAST_ROW_COUNT function, Oracle PL/SQL Programming
LAST_ROW_ID function
2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.10.3. The DBMS_SQL.LAST_ROW_ID function, Oracle Built-in Packages
C.14.12. The LAST_ROW_ID function, Oracle PL/SQL Programming
LAST_SQL_FUNCTION_CODE function
2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.10.4. The DBMS_SQL.LAST_SQL_FUNCTION_CODE function, Oracle Built-in Packages
C.14.13. The LAST_SQL_FUNCTION_CODE function, Oracle PL/SQL Programming
LEAST function: 13.3.3. The LEAST function, Oracle PL/SQL Programming
LENGTH function
9.2.3.11. The UTL_RAW.LENGTH function, Oracle Built-in Packages
11.1.6. The LENGTH function, Oracle PL/SQL Programming
LENGTH property
21.4.1. Datatype Conversion, Oracle PL/SQL Programming
21.4.3.2. LENGTH property, Oracle PL/SQL Programming
LIMIT function: 19.6.6. LIMIT, Oracle PL/SQL Programming
LISTEN procedure, DBMS_AQ package
7.6.4. Improved Publish/Subscribe Support, Guide to Oracle8i Features
7.6.4.2. LISTEN: Listening for messages, Guide to Oracle8i Features
LISTPRINT procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
LIST_CONTEXT procedure, DBMS_SESSION package
8.4. SYS_CONTEXT and LIST_CONTEXT: Obtaining Context Information, Guide to Oracle8i Features
8.1. FGAC Components, Guide to Oracle8i Features
8.4.2. LIST_CONTEXT: Obtaining the List of Defined Context Attributes, Guide to Oracle8i Features
LN function: 13.1.11. The LN function, Oracle PL/SQL Programming
LOADFROMFILE procedure
8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.1.7. The DBMS_LOB.LOADFROMFILE procedure, Oracle Built-in Packages
LOADLOBS package, loadjava utility: 9.4. Using loadjava, Guide to Oracle8i Features
LOB columns: (see LOBs, locators)
LOB variables: (see LOBs, locators)
LOBs
(see also DBMS_LOB package)
4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features
7.5. LOB Enhancements, Guide to Oracle8i Features
4.2.7. LOB Datatypes, Oracle PL/SQL Programming
8. Managing Large Objects , Oracle Built-in Packages
1.4.7.6. Large object support, Oracle PL/SQL Programming
BFILES: (see BFILEs)
BLOBs: 8.2.1. LOB Datatypes, Oracle Built-in Packages
CLOBs
8.2.1. LOB Datatypes, Oracle Built-in Packages
8.2.1.4. The CLOB datatype, Oracle Built-in Packages
DMBS_LOB package for: C.6. DBMS_LOB (PL/SQL8 Only), Oracle PL/SQL Programming
LONG datatypes and: 4.2.7.5. LOBs and LONGs, Oracle PL/SQL Programming
NCLOBs
8.2.1. LOB Datatypes, Oracle Built-in Packages
8.2.1.5. The NCLOB datatype, Oracle Built-in Packages
NULL data and locators: 8.2.3.3. NULL LOB locators can be a problem, Oracle Built-in Packages
appending: 8.3.3.1. The DBMS_LOB.APPEND procedure, Oracle Built-in Packages
comparing: 8.3.2.1. The DBMS_LOB.COMPARE function, Oracle Built-in Packages
concepts: 8.2. LOB Concepts, Oracle Built-in Packages
copying: 8.3.3.2. The DBMS_LOB.COPY procedure, Oracle Built-in Packages
cursors and: 8.2.1.1. Internal and external LOBs, Oracle Built-in Packages
datatypes for
4.2.7. LOB Datatypes, Oracle PL/SQL Programming
8.2.1. LOB Datatypes, Oracle Built-in Packages
emptying columns: 8.2.3.4. NULL versus "empty" LOB locators, Oracle Built-in Packages
erasing: 8.3.3.3. The DBMS_LOB.ERASE procedure, Oracle Built-in Packages
external
8.2.1.1. Internal and external LOBs, Oracle Built-in Packages
8.2.1.6. The LOB locator, Oracle Built-in Packages
functions for: 13.2. LOB Function Descriptions, Oracle PL/SQL Programming
internal
8.2.1.1. Internal and external LOBs, Oracle Built-in Packages
8.2.1.6. The LOB locator, Oracle Built-in Packages
8.2.3. Internal LOB Considerations, Oracle Built-in Packages
length of: 8.3.2.2. The DBMS_LOB.GETLENGTH function, Oracle Built-in Packages
locators: 8.2.1.6. The LOB locator, Oracle Built-in Packages
pattern matching: 8.3.2.5. The DBMS_LOB.INSTR function, Oracle Built-in Packages
performance improvement using RETURNING clause: 8.2.3.2. The RETURNING clause, Oracle Built-in Packages
queue storage and: 5.3.3. Queue Type Names, Oracle Built-in Packages
reading: 8.3.2. Reading and Examining LOBs, Oracle Built-in Packages
substrings of: 8.3.2.4. The DBMS_LOB.SUBSTR function, Oracle Built-in Packages
transactions and: 8.2.1.1. Internal and external LOBs, Oracle Built-in Packages
trimming: 8.3.3.4. The DBMS_LOB.TRIM procedure, Oracle Built-in Packages
writing: 8.3.3. Updating BLOBs, CLOBs, and NCLOBs, Oracle Built-in Packages
LOCAL_TRANSACTION_ID function
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.7.1. The DBMS_TRANSACTION.LOCAL_TRANSACTION_ID function, Oracle Built-in Packages
C.15.17. The LOCAL_TRANSACTION_ID function, Oracle PL/SQL Programming
LOCK TABLE statement
6.1.5. The LOCK TABLE Statement, Oracle PL/SQL Programming
3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features
LOCK_OBJECT procedure: 9.2.5.2. The UTL_REF.LOCK_OBJECT procedure, Oracle Built-in Packages
LOG function: 13.1.12. The LOG function, Oracle PL/SQL Programming
LOGIN_DENIED exception: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming
LOGIN_USER attribute, database-level event: 6.2. Database-Level Event Triggers, Guide to Oracle8i Features
LOGOFF events
1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
6. New Trigger Features in Oracle8i, Guide to Oracle8i Features
6.2. Database-Level Event Triggers, Guide to Oracle8i Features
LOGON events
1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
6. New Trigger Features in Oracle8i, Guide to Oracle8i Features
6.2. Database-Level Event Triggers, Guide to Oracle8i Features
6.2.1.2. Tracking logins to the database, Guide to Oracle8i Features
LONG RAW datatype
4.2.3.5. The LONG RAW datatype, Oracle PL/SQL Programming
LOB datatypes and: 4.2.7.5. LOBs and LONGs, Oracle PL/SQL Programming
converting to a LOB: 7.5.1. The TO_LOB Function, Guide to Oracle8i Features
LONG columns: 4.2.3.3. The LONG datatype, Oracle PL/SQL Programming
and VARCHAR2 handling: 4.2.3.2. The VARCHAR2 and VARCHAR datatypes, Oracle PL/SQL Programming
LONG datatype
4.2.3.3. The LONG datatype, Oracle PL/SQL Programming
LOB datatypes and: 4.2.7.5. LOBs and LONGs, Oracle PL/SQL Programming
LONG datatype, converting to a LOB: 7.5.1. The TO_LOB Function, Guide to Oracle8i Features
LONG values
retrieving: 2.3.8.2. The DBMS_SQL.COLUMN_VALUE_LONG procedure, Oracle Built-in Packages
static SELECT versus: 2.3.8.2. The DBMS_SQL.COLUMN_VALUE_LONG procedure, Oracle Built-in Packages
LONGNAME function, DBMS_JAVA package
9.7. Using DBMS_JAVA and DBMS_JAVA_TEST, Guide to Oracle8i Features
9.7.1. LONGNAME: Converting Java Long Names, Guide to Oracle8i Features
LOOP keywords: (see loops)
LOWER function: 11.1.7. The LOWER function, Oracle PL/SQL Programming
LPAD function
3.9. Considering Implementation Options, Advanced Oracle PL/SQL Programming with Packages
11.1.8. The LPAD function, Oracle PL/SQL Programming
LRU (least-recently used) algorithm: 1.4.3.1. Managing packages in shared memory, Advanced Oracle PL/SQL Programming with Packages
LTRIM function
11.1.9. The LTRIM function, Oracle PL/SQL Programming
25.4.2. Zen and the Art of PL/SQL Tuning, Oracle PL/SQL Programming
Large objects: (see LOBs)
Linux operating system: 1.1. What's in Oracle8i Release 8.1?, Guide to Oracle8i Features
l procedure
2.8.1.1. Supporting many data combinations, Advanced Oracle PL/SQL Programming with Packages
7.1. Using the l Procedure, Advanced Oracle PL/SQL Programming with Packages
7.4. Controlling Output from p, Advanced Oracle PL/SQL Programming with Packages
overloadings of: 5.2.4. The overloadings of the l procedure, Advanced Oracle PL/SQL Programming with Packages
PL/Vision: 6.1.6.1. Encapsulating DBMS_OUTPUT, Oracle Built-in Packages
labels
5.2.1. The GOTO Statement, Oracle PL/SQL Programming
delimiters for (>)
2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
5.2.1. The GOTO Statement, Oracle PL/SQL Programming
for blocks: 15.3.6. Block Labels, Oracle PL/SQL Programming
for loops
7.6.1. Loop Labels, Oracle PL/SQL Programming
and loop scope: 7.6.2.2. Scope with labels, Oracle PL/SQL Programming
language (NLS), setting: 11.1.2.3. The DBMS_SESSION.SET_NLS procedure, Oracle Built-in Packages
language version (SQL statement parsing): 2.2.6. DBMS_SQL Nonprogram Elements, Oracle Built-in Packages
laptops: 1.1. The Internet Grows Up, Oracle Web Applications
large objects: (see LOBs)
last-in, first-out queues: (see stacks)
last_line variable: 15.4.2.7. Showing code just once, Advanced Oracle PL/SQL Programming with Packages
lastsp function: 5.23.4. Managing savepoints , Advanced Oracle PL/SQL Programming with Packages
lava lamp effect: 2.9.2. Lava Lamp Code Consolidation, Advanced Oracle PL/SQL Programming with Packages
layaway package
(see also specific program names)
5.7.5. Searching by Correlation Identifier, Oracle Built-in Packages
layering packages: 2.9. Modularizing for Maintainable Packages, Advanced Oracle PL/SQL Programming with Packages
layers, code: (see packages)
least-recently used (LRU) algorithm: 1.4.3.1. Managing packages in shared memory, Advanced Oracle PL/SQL Programming with Packages
less than (<=) operator: 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
level (in DESCRIBE_PROCEDURE): 10.2.2.2. The DESCRIBE level, Oracle Built-in Packages
lexical units, PL/SQL: 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
libraries
1.2.2. The Client-Side Layers, Advanced Oracle PL/SQL Programming with Packages
1.5.2. Prebuilt Packages, Advanced Oracle PL/SQL Programming with Packages
dropping: 21.3.3. DROP: Dropping Libraries, Oracle PL/SQL Programming
lifo constant: 5.24.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
limit_ps procedure: 17.4.2. Setting the Page Size, Advanced Oracle PL/SQL Programming with Packages
line breaks: (see whitespace)
line function
5.11.9. Reading from a file, Advanced Oracle PL/SQL Programming with Packages
13.5.2. Reading the nth Line, Advanced Oracle PL/SQL Programming with Packages
line limit, WHERE clause: 12.4.3. Setting a Line Limit, Advanced Oracle PL/SQL Programming with Packages
line numbers, code
15.3. Displaying Source Code, Advanced Oracle PL/SQL Programming with Packages
23.6.6. Finding the Code for a Line Number, Oracle PL/SQL Programming
line prefix: 5.2.3. Setting the line prefix, Advanced Oracle PL/SQL Programming with Packages
line procedure
5.4.2. Case-converting programs, Advanced Oracle PL/SQL Programming with Packages
18.1.1.3. Converting a line, Advanced Oracle PL/SQL Programming with Packages
line separator
5.2.2. Setting the line separator, Advanced Oracle PL/SQL Programming with Packages
7.2. The Line Separator, Advanced Oracle PL/SQL Programming with Packages
line_type record: 5.15.2. Package records, Advanced Oracle PL/SQL Programming with Packages
line_with function: 5.15.5. Managing the source WHERE clause, Advanced Oracle PL/SQL Programming with Packages
line_with_text function: 6.2.7.4. Searching a file for a string, Oracle Built-in Packages
lines, changing case of: 18.1.1.3. Converting a line, Advanced Oracle PL/SQL Programming with Packages
linesep function
5.2.2. Setting the line separator, Advanced Oracle PL/SQL Programming with Packages
7.2. The Line Separator, Advanced Oracle PL/SQL Programming with Packages
linetext.sf : 6.2.7.4. Searching a file for a string, Oracle Built-in Packages
links: 1.2.1.2. Keeping sites up to date, Oracle Web Applications
links library, WebDB: 3.1.2.3. Building shared components, Oracle Web Applications
links.sql : 15.3.5.1. The DBMS_REPCAT.ADD_MASTER_DATABASE procedure, Oracle Built-in Packages
list of bailout errors: 22.1.10.1. Managing the bailout error list, Advanced Oracle PL/SQL Programming with Packages
list_full exception: 5.18.1. Package exceptions, Advanced Oracle PL/SQL Programming with Packages
list_undefined exception: 5.18.1. Package exceptions, Advanced Oracle PL/SQL Programming with Packages
listener for external procedures: 21.2.1. Step 1: Set Up the Listener, Oracle PL/SQL Programming
lists: 5.18. PLVlst: List Manager, Advanced Oracle PL/SQL Programming with Packages
copying file to: 5.11.11. Copying a file, Advanced Oracle PL/SQL Programming with Packages
copying files to: 13.7.3. Copying File to List, Advanced Oracle PL/SQL Programming with Packages
lists of values library, WebDB: 3.1.2.3. Building shared components, Oracle Web Applications
literals
1.6.1.4. Remove hard-coded literals from your application, Advanced Oracle PL/SQL Programming with Packages
3.12. Obliterating the Literals, Advanced Oracle PL/SQL Programming with Packages
2.3. Literals, Oracle PL/SQL Programming
4.7.4. Use Named Constants to Avoid Hardcoding Values, Oracle PL/SQL Programming
16.3.1.2. A package of magic values, Oracle PL/SQL Programming
PLV package: 6.6. The Predefined Constants, Advanced Oracle PL/SQL Programming with Packages
strings: (see strings)
user awareness of: 2.5.3. Avoiding Need for User to Know and Pass Literals, Advanced Oracle PL/SQL Programming with Packages
ln procedure: 6.1.6.2. Package specification for a DBMS_OUTPUT encapsulator, Oracle Built-in Packages
load_from_dbms procedure
5.19.2. Managing and accessing message text, Advanced Oracle PL/SQL Programming with Packages
9.2.2. Batch Loading of Message Text, Advanced Oracle PL/SQL Programming with Packages
9.6. Implementing load_ from_dbms, Advanced Oracle PL/SQL Programming with Packages
load_my_session_rec procedure
11.1.5.1. Adding value to DBMS_SESSION, Oracle Built-in Packages
11.1.5.3. The load_my_session_rec procedure, Oracle Built-in Packages
load_unique_id procedure
11.1.5.1. Adding value to DBMS_SESSION, Oracle Built-in Packages
11.1.5.2. The unique_id function, Oracle Built-in Packages
load_unused procedure: 12.1.3.1. The segspace package, Oracle Built-in Packages
loaded java elements, examining: 9.6.2. Examining Loaded Java Elements, Guide to Oracle8i Features
loading message text: 9.2.2. Batch Loading of Message Text, Advanced Oracle PL/SQL Programming with Packages
loadjava utility
9.1. Oracle8i and Java, Guide to Oracle8i Features
9.4. Using loadjava, Guide to Oracle8i Features
lob_loc, CREATETEMPORARY procedure: 7.5.2.1. CREATETEMPORARY: Creating a temporary LOB, Guide to Oracle8i Features
lobfuncs.ddl : 8.1.4. About the Examples, Oracle Built-in Packages
lobtabs.ddl : 8.1.4. About the Examples, Oracle Built-in Packages
local modules
1.7.1. Write as Little Code as Possible, Oracle PL/SQL Programming
15.7. Local Modules, Oracle PL/SQL Programming
22.3. Take Full Advantage of Local Modularization, Oracle PL/SQL Programming
forward declarations of: 15.9. Forward Declarations, Oracle PL/SQL Programming
scope of: 15.7.5. Scope of Local Modules, Oracle PL/SQL Programming
local variables
objects for: 18.1.2. Some Simple Examples, Oracle PL/SQL Programming
performance and: 25.4.3. Rely on Local Variables to Improve Performance, Oracle PL/SQL Programming
local variables, normalizing: 4.5.1.2. Normalization of local variables, Oracle PL/SQL Programming
location transparency: 2.5.3.2. Object privileges, Oracle Web Applications
lock identifiers: 4.1.2.2. The DBMS_LOCK.REQUEST function, Oracle Built-in Packages
lock modes
compatibility rules: 4.1.1.3. Lock compatibility rules, Oracle Built-in Packages
converting modes: 4.1.2.3. The DBMS_LOCK.CONVERT function, Oracle Built-in Packages
lock names: (see named locks)
lock1.sql : 4.1.3.3. Performance of named locks, Oracle Built-in Packages
lockhandle function: 4.1.4.1. The dblock package, Oracle Built-in Packages
lockhandles, returning: 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure, Oracle Built-in Packages
locking records
6.11. SELECT FOR UPDATE in Cursors, Oracle PL/SQL Programming
with DBMS_LOCK: (see DBMS_LOCK package)
locking tables: (see table locks)
locks: 2.1. Transaction Management in PL/SQL, Guide to Oracle8i Features
BFILE loading and: 8.3.1.7. The DBMS_LOB.LOADFROMFILE procedure, Oracle Built-in Packages
DDL statement execution and: 2.4.7. Executing DDL in PL/SQL, Oracle Built-in Packages
alert signaling and: 3.2.2.5. The DBMS_ALERT.SIGNAL procedure, Oracle Built-in Packages
allocating: 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure, Oracle Built-in Packages
commitment: (see commitment, locks)
converting versus requesting: 4.1.3.6. REQUEST or CONVERT?, Oracle Built-in Packages
deadlock notification: 4.1.2.2. The DBMS_LOCK.REQUEST function, Oracle Built-in Packages
dequeuing and: 5.3.8. Dequeue Options Record Type, Oracle Built-in Packages
handles for: 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure, Oracle Built-in Packages
identifiers for: 4.1.2.2. The DBMS_LOCK.REQUEST function, Oracle Built-in Packages
modes: (see lock modes)
named locks: (see named locks)
object locking: 9.2.5.2. The UTL_REF.LOCK_OBJECT procedure, Oracle Built-in Packages
persistence of: 4.1.2.2. The DBMS_LOCK.REQUEST function, Oracle Built-in Packages
releasing: 4.1.2.4. The DBMS_LOCK.RELEASE function, Oracle Built-in Packages
distributed databases and: 4.1.2.2. The DBMS_LOCK.REQUEST function, Oracle Built-in Packages
multithreaded server environments and: 4.1.2.2. The DBMS_LOCK.REQUEST function, Oracle Built-in Packages
requesting: 4.1.2.2. The DBMS_LOCK.REQUEST function, Oracle Built-in Packages
signaling service availability (example): 4.1.4.2. Using locks to signal service availability, Oracle Built-in Packages
suspending sessions: 4.1.2.5. The DBMS_LOCK.SLEEP procedure, Oracle Built-in Packages
triggers and
4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure, Oracle Built-in Packages
4.1.3.4. ALLOCATE_UNIQUE drawbacks, Oracle Built-in Packages
view for: 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure, Oracle Built-in Packages
log procedure: 21.1.2.1. Using put_line, Advanced Oracle PL/SQL Programming with Packages
logging
2.6.3. Changing Package Behavior Without Changing the Application, Advanced Oracle PL/SQL Programming with Packages
5.17. PLVlog: Logging Facility, Advanced Oracle PL/SQL Programming with Packages
21. PLVlog and PLVtrc: Logging and Tracing, Advanced Oracle PL/SQL Programming with Packages
21.1.2.1. Using put_line, Advanced Oracle PL/SQL Programming with Packages
commit activity: 5.7.2. Logging commit activity, Advanced Oracle PL/SQL Programming with Packages
commits: 20.1.5. Logging Commits , Advanced Oracle PL/SQL Programming with Packages
exceptions
5.10.3. Logging exception-handling activity, Advanced Oracle PL/SQL Programming with Packages
22.3.3.3. Recording the exception, Advanced Oracle PL/SQL Programming with Packages
hard-coding with exceptions: 22.3.2.2. Drawbacks of the usual handlers, Advanced Oracle PL/SQL Programming with Packages
rollbacks
5.23.2. Logging rollback activity, Advanced Oracle PL/SQL Programming with Packages
20.2.2. Logging Rollbacks , Advanced Oracle PL/SQL Programming with Packages
trace activity: 5.28.3. Writing to the PL/Vision log, Advanced Oracle PL/SQL Programming with Packages
trace messages: 21.2.1. Directing Output from PLVtrc, Advanced Oracle PL/SQL Programming with Packages
logging errors
22.1.7.1. Logging errors, Advanced Oracle PL/SQL Programming with Packages
example of: 2.5.1. Building an Autonomous Logging Mechanism, Guide to Oracle8i Features
logging function: 21.2.1. Directing Output from PLVtrc, Advanced Oracle PL/SQL Programming with Packages
logging level parameter, server settings: 3.2.3.1. Server settings, Oracle Web Applications
logging mechanisms
1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!), Guide to Oracle8i Features
2.3. When to Use Autonomous Transactions, Guide to Oracle8i Features
logic, conditional
A.1.1. Conditional Logic, Advanced Oracle PL/SQL Programming with Packages
A.2.1. Conditional Logic, Advanced Oracle PL/SQL Programming with Packages
logical datatype: (see Boolean datatype)
logical structure: 3.1.1. Revealing Logical Structure with Indentation, Oracle PL/SQL Programming
logical unit of work, registering: 7.2.3. The DBMS_APPLICATION_INFO.SET_ACTION procedure, Oracle Built-in Packages
login procedure, FORUM_USERS package
8.3.5. The FORUM_USERS Package, Oracle Web Applications
8.3.5.2. Body, Oracle Web Applications
login.sql file: 4.4.2. A PL/Vision Initialization Script for SQL*Plus, Advanced Oracle PL/SQL Programming with Packages
login_form procedure
8.3.5. The FORUM_USERS Package, Oracle Web Applications
8.3.5.2. Body, Oracle Web Applications
logins, tracking database: 6.2.1.2. Tracking logins to the database, Guide to Oracle8i Features
logtype function: 5.17.3. Selecting the log type, Advanced Oracle PL/SQL Programming with Packages
long SQL statements, parsing
2.2.6. DBMS_SQL Nonprogram Elements, Oracle Built-in Packages
2.3.3.2. Parsing very long SQL statements, Oracle Built-in Packages
long-running operations
7.1.3. DBMS_APPLICATION_INFO Nonprogram Elements, Oracle Built-in Packages
7.2.6. The DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure, Oracle Built-in Packages
7.3.9. Tracking Long-Running Processes, Oracle Built-in Packages
longops package
(see also specific program names)
1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
7.3.9. Tracking Long-Running Processes, Oracle Built-in Packages
longops.sql : 7.3.9. Tracking Long-Running Processes, Oracle Built-in Packages
loop index: 7.3. The Numeric FOR Loop, Oracle PL/SQL Programming
naming: 7.7.1. Naming Loop Indexes , Oracle PL/SQL Programming
nontrivial increments: 7.3.3. Handling Nontrivial Increments, Oracle PL/SQL Programming
using REVERSE: 7.3.1. Rules for Numeric FOR Loops, Oracle PL/SQL Programming
with loop scope: 7.6.2.1. Scope in FOR loops, Oracle PL/SQL Programming
loop scope: 7.6.2.2. Scope with labels, Oracle PL/SQL Programming
loopexec procedure
5.20.6. Programmatic cursor FOR loop elements, Advanced Oracle PL/SQL Programming with Packages
11.7. A Programmatic Cursor FOR Loop, Advanced Oracle PL/SQL Programming with Packages
loops
A.1.2. Loops, Advanced Oracle PL/SQL Programming with Packages
A.2.2. Loops, Advanced Oracle PL/SQL Programming with Packages
2.2. Using Effective Coding Style for Packages, Advanced Oracle PL/SQL Programming with Packages
7. Loops, Oracle PL/SQL Programming
FOR loop
1.7.1. Write as Little Code as Possible, Oracle PL/SQL Programming
1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming
GOTO statements within: 7.7.2.4. GOTO statements inside a loop, Oracle PL/SQL Programming
PL/SQL: 6.2.4. Loops, Oracle Web Applications
REPEAT UNTIL: 7.2.2. Emulating a REPEAT UNTIL Loop, Oracle PL/SQL Programming
RETURN statement within: 7.7.2.3. RETURN statement, Oracle PL/SQL Programming
WHILE: 7.5. The WHILE Loop, Oracle PL/SQL Programming
cursor FOR
1.6.4. The cursor FOR loop, Oracle PL/SQL Programming
7.4. The Cursor FOR Loop, Oracle PL/SQL Programming
exiting: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming
filling table rows with: 10.6.2. Iterative Assignment , Oracle PL/SQL Programming
formatting: 3.3.2. Formatting Loops, Oracle PL/SQL Programming
labels for: 7.6.1. Loop Labels, Oracle PL/SQL Programming
numeric FOR: 7.3. The Numeric FOR Loop, Oracle PL/SQL Programming
scope of: 7.6.2. Loop Scope, Oracle PL/SQL Programming
simple: 7.2. The Simple Loop, Oracle PL/SQL Programming
terminating with labels: 7.6.1.2. Loop termination using labels, Oracle PL/SQL Programming
lower_bound variable: 5.2. Bulk DML with the FORALL Statement, Guide to Oracle8i Features
lowercase: (see case)


Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Copyright © 2000 O'Reilly & Associates, Inc. All rights reserved.