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 | 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


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
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