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

Index: L

l procedure (PL/Vision) : 6.1.6.1. Encapsulating DBMS_OUTPUT

language (NLS), setting : 11.1.2.3. The DBMS_SESSION.SET_NLS procedure

language version (SQL statement parsing) : 2.2.6. DBMS_SQL Nonprogram Elements

large objects : (see LOBs)

last-in, first-out queues : (see stacks)

LAST_ERROR_POSITION function

2.2.3. DBMS_SQL Programs

2.3.10.1. The DBMS_SQL.LAST_ERROR_POSITION function

SQLERRM and : 2.3.10.1. The DBMS_SQL.LAST_ERROR_POSITION function

LAST_ROW_COUNT function

2.2.3. DBMS_SQL Programs

2.3.10.2. The DBMS_SQL.LAST_ROW_COUNT function

LAST_ROW_ID function

2.2.3. DBMS_SQL Programs

2.3.10.3. The DBMS_SQL.LAST_ROW_ID function

LAST_SQL_FUNCTION_CODE function

2.2.3. DBMS_SQL Programs

2.3.10.4. The DBMS_SQL.LAST_SQL_FUNCTION_CODE function

layaway package

(see also specific program names)

5.7.5. Searching by Correlation Identifier

LENGTH function : 9.2.3.11. The UTL_RAW.LENGTH function

level (in DESCRIBE_PROCEDURE) : 10.2.2.2. The DESCRIBE level

line_with_text function : 6.2.7.4. Searching a file for a string

linetext.sf : 6.2.7.4. Searching a file for a string

links.sql : 15.3.5.1. The DBMS_REPCAT.ADD_MASTER_DATABASE procedure

ln procedure : 6.1.6.2. Package specification for a DBMS_OUTPUT encapsulator

load_my_session_rec procedure

11.1.5.1. Adding value to DBMS_SESSION

11.1.5.3. The load_my_session_rec procedure

load_unique_id procedure

11.1.5.1. Adding value to DBMS_SESSION

11.1.5.2. The unique_id function

load_unused procedure : 12.1.3.1. The segspace package

LOADFROMFILE procedure

8.1.1. DBMS_LOB Programs

8.3.1.7. The DBMS_LOB.LOADFROMFILE procedure

LOB columns : (see LOBs, locators)

LOB variables : (see LOBs, locators)

lobfuncs.ddl : 8.1.4. About the Examples

LOBs

(see also DBMS_LOB package)

8. Managing Large Objects

appending : 8.3.3.1. The DBMS_LOB.APPEND procedure

BFILES : (see BFILEs)

BLOBs : 8.2.1. LOB Datatypes

CLOBs

8.2.1. LOB Datatypes

8.2.1.4. The CLOB datatype

comparing : 8.3.2.1. The DBMS_LOB.COMPARE function

concepts : 8.2. LOB Concepts

copying : 8.3.3.2. The DBMS_LOB.COPY procedure

cursors and : 8.2.1.1. Internal and external LOBs

datatypes : 8.2.1. LOB Datatypes

emptying columns : 8.2.3.4. NULL versus "empty" LOB locators

erasing : 8.3.3.3. The DBMS_LOB.ERASE procedure

external

8.2.1.1. Internal and external LOBs

8.2.1.6. The LOB locator

internal

8.2.1.1. Internal and external LOBs

8.2.1.6. The LOB locator

8.2.3. Internal LOB Considerations

length of : 8.3.2.2. The DBMS_LOB.GETLENGTH function

locators : 8.2.1.6. The LOB locator

NCLOBs

8.2.1. LOB Datatypes

8.2.1.5. The NCLOB datatype

NULL data and locators : 8.2.3.3. NULL LOB locators can be a problem

pattern matching : 8.3.2.5. The DBMS_LOB.INSTR function

performance improvement using RETURNING clause : 8.2.3.2. The RETURNING clause

queue storage and : 5.3.3. Queue Type Names

reading : 8.3.2. Reading and Examining LOBs

substrings of : 8.3.2.4. The DBMS_LOB.SUBSTR function

transactions and : 8.2.1.1. Internal and external LOBs

trimming : 8.3.3.4. The DBMS_LOB.TRIM procedure

writing : 8.3.3. Updating BLOBs, CLOBs, and NCLOBs

lobtabs.ddl : 8.1.4. About the Examples

LOCAL_TRANSACTION_ID function

4.2.1.1. DBMS_TRANSACTION programs

4.2.7.1. The DBMS_TRANSACTION.LOCAL_TRANSACTION_ID function

lock identifiers : 4.1.2.2. The DBMS_LOCK.REQUEST function

lock modes

compatibility rules : 4.1.1.3. Lock compatibility rules

converting modes : 4.1.2.3. The DBMS_LOCK.CONVERT function

lock names : (see named locks)

lock1.sql : 4.1.3.3. Performance of named locks

LOCK_OBJECT procedure : 9.2.5.2. The UTL_REF.LOCK_OBJECT procedure

lockhandle function : 4.1.4.1. The dblock package

lockhandles, returning : 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure

locks

alert signaling and : 3.2.2.5. The DBMS_ALERT.SIGNAL procedure

allocating : 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure

BFILE loading and : 8.3.1.7. The DBMS_LOB.LOADFROMFILE procedure

commitment : (see commitment, locks)

converting versus requesting : 4.1.3.6. REQUEST or CONVERT?

DDL statement execution and : 2.4.7. Executing DDL in PL/SQL

deadlock notification : 4.1.2.2. The DBMS_LOCK.REQUEST function

dequeuing and : 5.3.8. Dequeue Options Record Type

handles for : 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure

identifiers for : 4.1.2.2. The DBMS_LOCK.REQUEST function

modes : (see lock modes)

named locks : (see named locks)

object locking : 9.2.5.2. The UTL_REF.LOCK_OBJECT procedure

persistence of : 4.1.2.2. The DBMS_LOCK.REQUEST function

releasing : 4.1.2.4. The DBMS_LOCK.RELEASE function

distributed databases and : 4.1.2.2. The DBMS_LOCK.REQUEST function

multithreaded server environments and : 4.1.2.2. The DBMS_LOCK.REQUEST function

requesting : 4.1.2.2. The DBMS_LOCK.REQUEST function

signaling service availability (example) : 4.1.4.2. Using locks to signal service availability

suspending sessions : 4.1.2.5. The DBMS_LOCK.SLEEP procedure

triggers and

4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure

4.1.3.4. ALLOCATE_UNIQUE drawbacks

view for : 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure

logical unit of work, registering : 7.2.3. The DBMS_APPLICATION_INFO.SET_ACTION procedure

long SQL statements, parsing

2.2.6. DBMS_SQL Nonprogram Elements

2.3.3.2. Parsing very long SQL statements

LONG values

retrieving : 2.3.8.2. The DBMS_SQL.COLUMN_VALUE_LONG procedure

static SELECT versus : 2.3.8.2. The DBMS_SQL.COLUMN_VALUE_LONG procedure

long-running operations

7.1.3. DBMS_APPLICATION_INFO Nonprogram Elements

7.2.6. The DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure

7.3.9. Tracking Long-Running Processes

longops package

(see also specific program names)

1.3.5.1. Examples of encapsulation packages

7.3.9. Tracking Long-Running Processes

longops.sql : 7.3.9. Tracking Long-Running Processes

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