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

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