start page | rating of books | rating of authors | reviews | copyrights
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
Index: L
- LAN: 1.1. The Internet Grows Up, Oracle Web Applications
- LAST function
- 10.8.2. PL/SQL Table Built-ins, Oracle PL/SQL Programming
- 10.8.2.5. The LAST function, Oracle PL/SQL Programming
- 19.6.5. FIRST, LAST, Oracle PL/SQL Programming
LAST_DAY function: 12.1.2. The LAST_DAY function, Oracle PL/SQL Programming LAST_ERROR_POSITION function - 2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
- 2.3.10.1. The DBMS_SQL.LAST_ERROR_POSITION function, Oracle Built-in Packages
- C.14.10. The LAST_ERROR_POSITION function, Oracle PL/SQL Programming
- SQLERRM and: 2.3.10.1. The DBMS_SQL.LAST_ERROR_POSITION function, Oracle Built-in Packages
LAST_ROW_COUNT function - 2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
- 2.3.10.2. The DBMS_SQL.LAST_ROW_COUNT function, Oracle Built-in Packages
- C.14.11. The LAST_ROW_COUNT function, Oracle PL/SQL Programming
LAST_ROW_ID function - 2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
- 2.3.10.3. The DBMS_SQL.LAST_ROW_ID function, Oracle Built-in Packages
- C.14.12. The LAST_ROW_ID function, Oracle PL/SQL Programming
LAST_SQL_FUNCTION_CODE function - 2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
- 2.3.10.4. The DBMS_SQL.LAST_SQL_FUNCTION_CODE function, Oracle Built-in Packages
- C.14.13. The LAST_SQL_FUNCTION_CODE function, Oracle PL/SQL Programming
LEAST function: 13.3.3. The LEAST function, Oracle PL/SQL Programming LENGTH function - 9.2.3.11. The UTL_RAW.LENGTH function, Oracle Built-in Packages
- 11.1.6. The LENGTH function, Oracle PL/SQL Programming
LENGTH property - 21.4.1. Datatype Conversion, Oracle PL/SQL Programming
- 21.4.3.2. LENGTH property, Oracle PL/SQL Programming
LIMIT function: 19.6.6. LIMIT, Oracle PL/SQL Programming LISTEN procedure, DBMS_AQ package - 7.6.4. Improved Publish/Subscribe Support, Guide to Oracle8i Features
- 7.6.4.2. LISTEN: Listening for messages, Guide to Oracle8i Features
LISTPRINT procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications LIST_CONTEXT procedure, DBMS_SESSION package - 8.4. SYS_CONTEXT and LIST_CONTEXT: Obtaining Context Information, Guide to Oracle8i Features
- 8.1. FGAC Components, Guide to Oracle8i Features
- 8.4.2. LIST_CONTEXT: Obtaining the List of Defined Context Attributes, Guide to Oracle8i Features
LN function: 13.1.11. The LN function, Oracle PL/SQL Programming LOADFROMFILE procedure - 8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
- 8.3.1.7. The DBMS_LOB.LOADFROMFILE procedure, Oracle Built-in Packages
LOADLOBS package, loadjava utility: 9.4. Using loadjava, Guide to Oracle8i Features LOB columns: (see LOBs, locators) LOB variables: (see LOBs, locators) LOBs - (see also DBMS_LOB package)
- 4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features
- 7.5. LOB Enhancements, Guide to Oracle8i Features
- 4.2.7. LOB Datatypes, Oracle PL/SQL Programming
- 8. Managing Large Objects , Oracle Built-in Packages
- 1.4.7.6. Large object support, Oracle PL/SQL Programming
- BFILES: (see BFILEs)
- BLOBs: 8.2.1. LOB Datatypes, Oracle Built-in Packages
- CLOBs
- 8.2.1. LOB Datatypes, Oracle Built-in Packages
- 8.2.1.4. The CLOB datatype, Oracle Built-in Packages
DMBS_LOB package for: C.6. DBMS_LOB (PL/SQL8 Only), Oracle PL/SQL Programming
LONG datatypes and: 4.2.7.5. LOBs and LONGs, Oracle PL/SQL Programming
NCLOBs - 8.2.1. LOB Datatypes, Oracle Built-in Packages
- 8.2.1.5. The NCLOB datatype, Oracle Built-in Packages
NULL data and locators: 8.2.3.3. NULL LOB locators can be a problem, Oracle Built-in Packages appending: 8.3.3.1. The DBMS_LOB.APPEND procedure, Oracle Built-in Packages comparing: 8.3.2.1. The DBMS_LOB.COMPARE function, Oracle Built-in Packages concepts: 8.2. LOB Concepts, Oracle Built-in Packages copying: 8.3.3.2. The DBMS_LOB.COPY procedure, Oracle Built-in Packages cursors and: 8.2.1.1. Internal and external LOBs, Oracle Built-in Packages datatypes for
- 4.2.7. LOB Datatypes, Oracle PL/SQL Programming
- 8.2.1. LOB Datatypes, Oracle Built-in Packages
emptying columns: 8.2.3.4. NULL versus "empty" LOB locators, Oracle Built-in Packages erasing: 8.3.3.3. The DBMS_LOB.ERASE procedure, Oracle Built-in Packages external - 8.2.1.1. Internal and external LOBs, Oracle Built-in Packages
- 8.2.1.6. The LOB locator, Oracle Built-in Packages
functions for: 13.2. LOB Function Descriptions, Oracle PL/SQL Programming
internal - 8.2.1.1. Internal and external LOBs, Oracle Built-in Packages
- 8.2.1.6. The LOB locator, Oracle Built-in Packages
- 8.2.3. Internal LOB Considerations, Oracle Built-in Packages
length of: 8.3.2.2. The DBMS_LOB.GETLENGTH function, Oracle Built-in Packages locators: 8.2.1.6. The LOB locator, Oracle Built-in Packages pattern matching: 8.3.2.5. The DBMS_LOB.INSTR function, Oracle Built-in Packages performance improvement using RETURNING clause: 8.2.3.2. The RETURNING clause, Oracle Built-in Packages queue storage and: 5.3.3. Queue Type Names, Oracle Built-in Packages reading: 8.3.2. Reading and Examining LOBs, Oracle Built-in Packages substrings of: 8.3.2.4. The DBMS_LOB.SUBSTR function, Oracle Built-in Packages transactions and: 8.2.1.1. Internal and external LOBs, Oracle Built-in Packages trimming: 8.3.3.4. The DBMS_LOB.TRIM procedure, Oracle Built-in Packages writing: 8.3.3. Updating BLOBs, CLOBs, and NCLOBs, Oracle Built-in Packages LOCAL_TRANSACTION_ID function - 4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
- 4.2.7.1. The DBMS_TRANSACTION.LOCAL_TRANSACTION_ID function, Oracle Built-in Packages
- C.15.17. The LOCAL_TRANSACTION_ID function, Oracle PL/SQL Programming
LOCK TABLE statement
- 6.1.5. The LOCK TABLE Statement, Oracle PL/SQL Programming
- 3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features
LOCK_OBJECT procedure: 9.2.5.2. The UTL_REF.LOCK_OBJECT procedure, Oracle Built-in Packages LOG function: 13.1.12. The LOG function, Oracle PL/SQL Programming LOGIN_DENIED exception: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming LOGIN_USER attribute, database-level event: 6.2. Database-Level Event Triggers, Guide to Oracle8i Features LOGOFF events - 1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
- 6. New Trigger Features in Oracle8i, Guide to Oracle8i Features
- 6.2. Database-Level Event Triggers, Guide to Oracle8i Features
LOGON events - 1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
- 6. New Trigger Features in Oracle8i, Guide to Oracle8i Features
- 6.2. Database-Level Event Triggers, Guide to Oracle8i Features
- 6.2.1.2. Tracking logins to the database, Guide to Oracle8i Features
LONG RAW datatype
4.2.3.5. The LONG RAW datatype, Oracle PL/SQL Programming - 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 login procedure, FORUM_USERS package - 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
Copyright © 2000 O'Reilly & Associates, Inc. All rights reserved.