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 (>) : The GOTO Statement
• labels : The GOTO Statement
• • delimiters for (>) : The PL/SQL Character Set
  • for loops : Loop Labels
  • • and loop scope : Scope with labels
• labels for blocks : Block Labels
• large objects : (see LOBs)
• LAST function
• • PL/SQL Table Built-ins
  • The LAST function
  • FIRST, LAST
• LAST_DAY function : The LAST_DAY function
• LAST_ERROR_POSITION function : The LAST_ERROR_POSITION function
• LAST_ROW_COUNT function : The LAST_ROW_COUNT function
• LAST_ROW_ID function : The LAST_ROW_ID function
• LAST_SQL_FUNCTION_CODE function : The LAST_SQL_FUNCTION_CODE function
• LEAST function : The LEAST function
• LENGTH function : The LENGTH function
• LENGTH property
• • Datatype Conversion
  • LENGTH property
• less than (<=) operator : The PL/SQL Character Set
• lexical units, PL/SQL : The PL/SQL Character Set
• libraries dropping : DROP: Dropping Libraries
• LIMIT function : LIMIT
• line breaks : (see whitespace)
• line number, finding code for : Finding the Code for a Line Number
• listener for external procedures : Step 1: Set Up the Listener
• literals
• • Literals
  • Use Named Constants to Avoid Hardcoding Values
  • package of magic values
  • strings : (see strings)
• LN function : The LN function
• LOBs (large object datatypes) : Large object support
• • functions for : LOB Function Descriptions
• LOBs (large objects) : LOB Datatypes
• • datatypes for : LOB Datatypes
  • DMBS_LOB package for : DBMS_LOB (PL/SQL8 Only)
  • LONG datatypes and : LOBs and LONGs
• local modules
• • Write as Little Code as Possible
  • Local Modules
  • Take Full Advantage of Local Modularization
  • forward declarations of : Forward Declarations
  • scope of : Scope of Local Modules
• local variables
• • objects for : Some Simple Examples
  • performance and : Rely on Local Variables to Improve Performance
• local variables, normalizing : Normalization of local variables
• LOCAL_TRANSACTION_ID function : The LOCAL_TRANSACTION_ID function
• LOCK TABLE statement : The LOCK TABLE Statement
• locking records
• • SELECT FOR UPDATE in Cursors
  • with DBMS_LOCK : (see DBMS_LOCK package)
• locking tables : (see table locks)
• LOG function : The LOG function
• logical datatype : (see Boolean datatype)
• logical structure : Revealing Logical Structure with Indentation
• LOGIN_DENIED exception : Named System Exceptions
• LONG columns : The LONG datatype
• • and VARCHAR2 handling : The VARCHAR2 and VARCHAR datatypes
• LONG datatype : The LONG datatype
• • LOB datatypes and : LOBs and LONGs
• LONG RAW datatype : The LONG RAW datatype
• • LOB datatypes and : LOBs and LONGs
• loop index : The Numeric FOR Loop
• • with loop scope : Scope in FOR loops
  • naming : Naming Loop Indexes
  • nontrivial increments : Handling Nontrivial Increments
  • using REVERSE : Rules for Numeric FOR Loops
• LOOP keywords : (see loops)
• loop scope : Scope with labels
• loops : Loops
• • cursor FOR
  • • The cursor FOR loop
    • The Cursor FOR Loop
  • exiting : Structured Code and Other Best Practices
  • filling table rows with : Iterative Assignment
  • FOR loop
  • • Write as Little Code as Possible
    • Structured Code and Other Best Practices
  • formatting : Formatting Loops
  • GOTO statements within : GOTO statements inside a loop
  • labels for : Loop Labels
  • numeric FOR : The Numeric FOR Loop
  • REPEAT UNTIL : Emulating a REPEAT UNTIL Loop
  • RETURN statement within : RETURN statement
  • scope of : Loop Scope
  • simple : The Simple Loop
  • terminating with labels : Loop termination using labels
  • WHILE : The WHILE Loop
• LOWER function : The LOWER function
• lowercase : (see case)
• LPAD function : The LPAD function
• LTRIM function
• • The LTRIM function
  • Zen and the Art of PL/SQL Tuning