Book HomeBook HomeSearch this book

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

Index: L

label delimeters (>) : 5.2.1. The GOTO Statement
labels : 5.2.1. The GOTO Statement
delimiters for (>) : 2.1. The PL/SQL Character Set
for loops : 7.6.1. Loop Labels
and loop scope : 7.6.2.2. Scope with labels
labels for blocks : 15.3.6. Block Labels
large objects : (see LOBs)
LAST function
10.8.2. PL/SQL Table Built-ins
10.8.2.5. The LAST function
19.6.5. FIRST, LAST
LAST_DAY function : 12.1.2. The LAST_DAY function
LAST_ERROR_POSITION function : C.14.10. The LAST_ERROR_POSITION function
LAST_ROW_COUNT function : C.14.11. The LAST_ROW_COUNT function
LAST_ROW_ID function : C.14.12. The LAST_ROW_ID function
LAST_SQL_FUNCTION_CODE function : C.14.13. The LAST_SQL_FUNCTION_CODE function
LEAST function : 13.3.3. The LEAST function
LENGTH function : 11.1.6. The LENGTH function
LENGTH property
21.4.1. Datatype Conversion
21.4.3.2. LENGTH property
less than (<=) operator : 2.1. The PL/SQL Character Set
lexical units, PL/SQL : 2.1. The PL/SQL Character Set
libraries dropping : 21.3.3. DROP: Dropping Libraries
LIMIT function : 19.6.6. LIMIT
line breaks : (see whitespace)
line number, finding code for : 23.6.6. Finding the Code for a Line Number
listener for external procedures : 21.2.1. Step 1: Set Up the Listener
literals
2.3. Literals
4.7.4. Use Named Constants to Avoid Hardcoding Values
16.3.1.2. A package of magic values
strings : (see strings)
LN function : 13.1.11. The LN function
LOBs (large object datatypes) : 1.4.7.6. Large object support
functions for : 13.2. LOB Function Descriptions
LOBs (large objects) : 4.2.7. LOB Datatypes
datatypes for : 4.2.7. LOB Datatypes
DMBS_LOB package for : C.6. DBMS_LOB (PL/SQL8 Only)
LONG datatypes and : 4.2.7.5. LOBs and LONGs
local modules
1.7.1. Write as Little Code as Possible
15.7. Local Modules
22.3. Take Full Advantage of Local Modularization
forward declarations of : 15.9. Forward Declarations
scope of : 15.7.5. Scope of Local Modules
local variables
objects for : 18.1.2. Some Simple Examples
performance and : 25.4.3. Rely on Local Variables to Improve Performance
local variables, normalizing : 4.5.1.2. Normalization of local variables
LOCAL_TRANSACTION_ID function : C.15.17. The LOCAL_TRANSACTION_ID function
LOCK TABLE statement : 6.1.5. The LOCK TABLE Statement
locking records
6.11. SELECT FOR UPDATE in Cursors
with DBMS_LOCK : (see DBMS_LOCK package)
locking tables : (see table locks)
LOG function : 13.1.12. The LOG function
logical datatype : (see Boolean datatype)
logical structure : 3.1.1. Revealing Logical Structure with Indentation
LOGIN_DENIED exception : 8.3.1. Named System Exceptions
LONG columns : 4.2.3.3. The LONG datatype
and VARCHAR2 handling : 4.2.3.2. The VARCHAR2 and VARCHAR datatypes
LONG datatype : 4.2.3.3. The LONG datatype
LOB datatypes and : 4.2.7.5. LOBs and LONGs
LONG RAW datatype : 4.2.3.5. The LONG RAW datatype
LOB datatypes and : 4.2.7.5. LOBs and LONGs
loop index : 7.3. The Numeric FOR Loop
with loop scope : 7.6.2.1. Scope in FOR loops
naming : 7.7.1. Naming Loop Indexes
nontrivial increments : 7.3.3. Handling Nontrivial Increments
using REVERSE : 7.3.1. Rules for Numeric FOR Loops
LOOP keywords : (see loops)
loop scope : 7.6.2.2. Scope with labels
loops : 7. Loops
cursor FOR
1.6.4. The cursor FOR loop
7.4. The Cursor FOR Loop
exiting : 1.7.5. Structured Code and Other Best Practices
filling table rows with : 10.6.2. Iterative Assignment
FOR loop
1.7.1. Write as Little Code as Possible
1.7.5. Structured Code and Other Best Practices
formatting : 3.3.2. Formatting Loops
GOTO statements within : 7.7.2.4. GOTO statements inside a loop
labels for : 7.6.1. Loop Labels
numeric FOR : 7.3. The Numeric FOR Loop
REPEAT UNTIL : 7.2.2. Emulating a REPEAT UNTIL Loop
RETURN statement within : 7.7.2.3. RETURN statement
scope of : 7.6.2. Loop Scope
simple : 7.2. The Simple Loop
terminating with labels : 7.6.1.2. Loop termination using labels
WHILE : 7.5. The WHILE Loop
LOWER function : 11.1.7. The LOWER function
lowercase : (see case)
LPAD function : 11.1.8. The LPAD function
LTRIM function
11.1.9. The LTRIM function
25.4.2. Zen and the Art of PL/SQL Tuning


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

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference