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

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