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

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