home | O'Reilly's CD bookshelfs | FreeBSD | Linux | Cisco | Cisco Exam  

CD Home

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

"snapshot too old" error: 20.1.1.1. Commit processing challenges, Advanced Oracle PL/SQL Programming with Packages
SAVEPOINT procedure
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.4.3. The DBMS_TRANSACTION.SAVEPOINT procedure, Oracle Built-in Packages
C.15.12. The SAVEPOINT procedure , Oracle PL/SQL Programming
6.1.3. The SAVEPOINT Statement, Oracle PL/SQL Programming
SCHEDULE_EXECUTION procedure
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.5.3. The DBMS_DEFER_SYS.SCHEDULE_EXECUTION procedure, Oracle Built-in Packages
SCHEDULE_PROPAGATION procedure
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.5.1. The DBMS_AQADM.SCHEDULE_PROPAGATION procedure, Oracle Built-in Packages
SCHEDULE_PURGE procedure
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.6.4. The DBMS_DEFER_SYS.SCHEDULE_PURGE procedure (Oracle8 only), Oracle Built-in Packages
SCHEDULE_PUSH procedure
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.6.5. The DBMS_DEFER_SYS.SCHEDULE_PUSH procedure (Oracle8 only), Oracle Built-in Packages
SCHEMA column,*_CONTEXT data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
SEED procedure
10.4.1. Getting Started with DBMS_RANDOM, Oracle Built-in Packages
10.4.2.2. The DBMS_RANDOM.SEED procedure (Oracle8 only), Oracle Built-in Packages
SEL column, *_POLICIES data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
SELECT COUNT(*): 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming
SELECT INTO clause
5.3. Bulk Querying with the BULK COLLECT Clause, Guide to Oracle8i Features
9.5.2. SELECT INTO from an Implicit Cursor, Oracle PL/SQL Programming
SELECT statement
1.6.1.5. Isolate volatile areas of functionality, Advanced Oracle PL/SQL Programming with Packages
3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features
SELECT FOR UPDATE statement
6.11. SELECT FOR UPDATE in Cursors, Oracle PL/SQL Programming
6.13.2. Managing a Work Queue with SELECT FOR UPDATE, Oracle PL/SQL Programming
SELECT INTO statement, initializing collections: 19.4.1.3. Initializing implicitly via fetch, Oracle PL/SQL Programming
THE function with: 19.5.1. The THE Pseudo-function, Oracle PL/SQL Programming
assigning objects: 18.4.1.3. Assignment via FETCH (with SELECT), Oracle PL/SQL Programming
cursors and: 6.2. Cursors in PL/SQL, Oracle PL/SQL Programming
in cursor declarations: 6.4. Declaring Cursors, Oracle PL/SQL Programming
SELECT statements
(see also DML statements)
4.2.3.2. The VARCHAR2 and VARCHAR datatypes, Oracle PL/SQL Programming
9.1.5. Referencing a Record and its Fields, Oracle PL/SQL Programming
10.3. PL/SQL Tables and DML Statements, Oracle PL/SQL Programming
LONG values versus: 2.3.8.2. The DBMS_SQL.COLUMN_VALUE_LONG procedure, Oracle Built-in Packages
constructing (example): 2.5.4.3. Constructing the SELECT, Oracle Built-in Packages
defining columns for: 2.3.1. Processing Flow of Dynamic SQL, Oracle Built-in Packages
dynamic execution of: 2. Executing Dynamic SQL and PL/SQL, Oracle Built-in Packages
source: 12.4.1. Viewing the Current Source SELECT, Advanced Oracle PL/SQL Programming with Packages
SELECT...BULK COLLECT statement: 5.3. Bulk Querying with the BULK COLLECT Clause, Guide to Oracle8i Features
SELECT_OBJECT procedure: 9.2.5.3. The UTL_REF.SELECT_OBJECT procedure, Oracle Built-in Packages
SELF object
18.1.2. Some Simple Examples, Oracle PL/SQL Programming
18.3.5. SELF: The Implied Parameter, Oracle PL/SQL Programming
IN mode for: 18.3.4.2. Dots in method invocations, Oracle PL/SQL Programming
SEND procedure, OWA_COOKIE package: 7.3.1.2. Procedures and functions, Oracle Web Applications
SEND_AND_COMPARE_OLD_VALUES procedure
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.8.3. The DBMS_REPCAT.SEND_AND_COMPARE_OLD_VALUES procedure (Oracle8 only), Oracle Built-in Packages
SEND_MESSAGE function
3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function, Oracle Built-in Packages
C.10.8. The SEND_MESSAGE function, Oracle PL/SQL Programming
creating pipes: 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function, Oracle Built-in Packages
SERIALIZABLE isolation level: 2.4.2. Transaction Visibility, Guide to Oracle8i Features
SERVERERROR 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
SERVER_ERROR attribute, database-level event: 6.2. Database-Level Event Triggers, Guide to Oracle8i Features
SESSION_USER attribute, SYS_CONTEXT function: 8.4.1. The SYS_CONTEXT Function, Guide to Oracle8i Features
SESSION_USERID attribute, SYS_CONTEXT function: 8.4.1. The SYS_CONTEXT Function, Guide to Oracle8i Features
SET PAGESIZE command: 17.5.6. Page Pausing with PLVhlp.more, Advanced Oracle PL/SQL Programming with Packages
SET PAUSE ON command: 17.5.6. Page Pausing with PLVhlp.more, Advanced Oracle PL/SQL Programming with Packages
SET SERVEROUTPUT (SQL*)
6.1.2.2. The DBMS_OUTPUT.DISABLE procedure, Oracle Built-in Packages
6.1.5. Tips on Using DBMS_OUTPUT, Oracle Built-in Packages
SET SERVEROUTPUT command: 7.1.2. Displaying Dates, Advanced Oracle PL/SQL Programming with Packages
SET TRANSACTION statement
2.4.2. Transaction Visibility, Guide to Oracle8i Features
6.1.4. The SET TRANSACTION Statement, Oracle PL/SQL Programming
SET clause
6.1. Triggers on Nested Table View Columns, Guide to Oracle8i Features
array updating and: 2.5.6.3. Using array processing to update, Oracle Built-in Packages
functions in: 17.1. Looking at the Problem, Oracle PL/SQL Programming
SET_ACTION procedure
7.1.1. DBMS_APPLICATION_INFO Programs , Oracle Built-in Packages
7.2.3. The DBMS_APPLICATION_INFO.SET_ACTION procedure, Oracle Built-in Packages
SET_AUTHORIZATION procedure, OWA_SEC package: 7.4.2. OWA_SEC: Managing Security , Oracle Web Applications
SET_BLOCK_PROPERTY: 14.3.4. Using TO_CHAR to Create a Date Range, Oracle PL/SQL Programming
SET_CLIENT_INFO procedure
7.1.1. DBMS_APPLICATION_INFO Programs , Oracle Built-in Packages
7.2.4. The DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure, Oracle Built-in Packages
SET_CLOSE_CACHED_OPEN_CURSORS procedure
11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
11.1.4.4. The DBMS_SESSION.SET_CLOSE_CACHED_OPEN_CURSORS procedure, Oracle Built-in Packages
SET_COLUMNS procedure
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.3.2. The DBMS_REPCAT.SET_COLUMNS procedure, Oracle Built-in Packages
SET_COMPILER procedure: 9.7.2. GET_, SET_, and RESET_COMPILER OPTIONS: Getting and Setting Compiler Options , Guide to Oracle8i Features
SET_COMPILER_OPTION procedure: 9.7. Using DBMS_JAVA and DBMS_JAVA_TEST, Guide to Oracle8i Features
SET_CONTEXT procedure
8.3. SET_CONTEXT: Setting Context and Attribute Values, Guide to Oracle8i Features
8.1. FGAC Components, Guide to Oracle8i Features
SET_DEFAULTS procedure
3.2.1.1. DBMS_ALERT programs, Oracle Built-in Packages
3.2.2.4. The DBMS_ALERT.SET_DEFAULTS procedure, Oracle Built-in Packages
C.2.4. The SET_DEFAULTS procedure, Oracle PL/SQL Programming
SET_DISABLED procedure
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.4.5. The DBMS_DEFER_SYS.SET_DISABLED procedure, Oracle Built-in Packages
SET_EV procedure
11.2.1. Getting Started with DBMS_SYSTEM , Oracle Built-in Packages
11.2.2.2. The DBMS_SYSTEM.SET_EV procedure, Oracle Built-in Packages
SET_I_AM_A_REFRESH procedure
14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
14.1.2.2. The DBMS_SNAPSHOT.SET_I_AM_A_REFRESH procedure, Oracle Built-in Packages
SET_LABEL procedure
11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
11.1.2.1. The DBMS_SESSION.SET_LABEL procedure, Oracle Built-in Packages
C.12.4. The SET_LABEL procedure, Oracle PL/SQL Programming
SET_MLS_LABEL procedure: C.12.5. The SET_NLS_LABEL procedure, Oracle PL/SQL Programming
SET_MLS_LABEL_FORMAT procedure
11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
11.1.2.2. DBMS_SESSION.SET_MLS_LABEL_FORMAT procedure, Oracle Built-in Packages
SET_MODULE procedure
7.1.1. DBMS_APPLICATION_INFO Programs , Oracle Built-in Packages
7.2.5. The DBMS_APPLICATION_INFO.SET_MODULE procedure, Oracle Built-in Packages
SET_NLS procedure
11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
11.1.2.3. The DBMS_SESSION.SET_NLS procedure, Oracle Built-in Packages
C.12.6. The SET_NLS procedure, Oracle PL/SQL Programming
SET_OUTPUT procedure
9.7. Using DBMS_JAVA and DBMS_JAVA_TEST, Guide to Oracle8i Features
9.7.3. SET_OUTPUT: Enabling Output from Java , Guide to Oracle8i Features
SET_PLSQL_TRACE procedure, DBMS_TRACE package: 7.2.2. DBMS_TRACE Programs , Guide to Oracle8i Features
SET_PROTECTION_REALM procedure, OWA_SEC package: 7.4.2. OWA_SEC: Managing Security , Oracle Web Applications
SET_ROLE procedure
11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
11.1.2.4. The DBMS_SESSION.SET_ROLE procedure, Oracle Built-in Packages
C.12.7. The SET_ROLE procedure, Oracle PL/SQL Programming
SET_SESSION_LONGOPS procedure
7.1.1. DBMS_APPLICATION_INFO Programs , 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
encapsulating: 7.3.9. Tracking Long-Running Processes, Oracle Built-in Packages
SET_SQL_TRACE procedure
11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
11.1.4.5. The DBMS_SESSION.SET_SQL_TRACE procedure, Oracle Built-in Packages
C.12.8. The SET_SQL_TRACE procedure, Oracle PL/SQL Programming
SET_SQL_TRACE_IN_SESSION procedure
11.2.1. Getting Started with DBMS_SYSTEM , Oracle Built-in Packages
11.2.2.3. The DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure, Oracle Built-in Packages
SET_UP procedure: C.13.6. The SET_UP procedure, Oracle PL/SQL Programming
SGA (System Global Area)
1.4.3. The Memory-Resident Architecture of Packages, Advanced Oracle PL/SQL Programming with Packages
1.6.3. The Initialization Section, Advanced Oracle PL/SQL Programming with Packages
4.4.1. Binding Versus Concatenation, Guide to Oracle8i Features
DBMS_PIPE package and: 1.5.1.1. Leveraging builtin packages, Advanced Oracle PL/SQL Programming with Packages
pinning critical code in: 25.2.2. Pin Critical Code into the SGA, Oracle PL/SQL Programming
tuning shared pool size: 25.2.1. Tune the Size of the Shared Pool of the SGA, Oracle PL/SQL Programming
SGML (Standardized General Markup Language): 9. XML, Oracle Web Applications
SHARED_POOL_SIZE constant: 1.4.3.1. Managing packages in shared memory, Advanced Oracle PL/SQL Programming with Packages
SHOW ERRORS command: 15.1.2. What SHOW ERRORS Does, Advanced Oracle PL/SQL Programming with Packages
SHOWPAGE procedure: 7.4.1.1. Debugging, Oracle Web Applications
SHOWSOURCE procedure: 7.4.1.1. Debugging, Oracle Web Applications
SHUTDOWN 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
SIGN function: 13.1.16. The SIGN function, Oracle PL/SQL Programming
SIGNAL procedure
3.2.1.1. DBMS_ALERT programs, Oracle Built-in Packages
3.2.2.5. The DBMS_ALERT.SIGNAL procedure, Oracle Built-in Packages
C.2.5. The SIGNAL procedure, Oracle PL/SQL Programming
SIGNATURE procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications
SIN function: 13.1.17. The SIN function, Oracle PL/SQL Programming
SINH function: 13.1.18. The SINH function, Oracle PL/SQL Programming
SIZES procedure
12.2.1. Getting Started with DBMS_SHARED_POOL, Oracle Built-in Packages
12.2.3.1. The DBMS_SHARED_POOL.SIZES procedure, Oracle Built-in Packages
SLEEP procedure
17.5.6.1. A futile first effort, Advanced Oracle PL/SQL Programming with Packages
4.1.1.1. DBMS_LOCK programs, Oracle Built-in Packages
4.1.2.5. The DBMS_LOCK.SLEEP procedure, Oracle Built-in Packages
C.7.5. The SLEEP procedure, Oracle PL/SQL Programming
SMALLINT subtype: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming
SMB: 1.3.1. The Internet File System, Oracle Web Applications
SMTP: 1.3.1. The Internet File System, Oracle Web Applications
SNAPSHOT_TOO_OLD exception: 22.1.2. Package-Based Exceptions, Advanced Oracle PL/SQL Programming with Packages
SNP background processes: 13.2.1.1. JOB_QUEUE_PROCESSES , Oracle Built-in Packages
SOUNDEX function: 11.1.13. The SOUNDEX function, Oracle PL/SQL Programming
SQL
ALTER SESSION commands: C.12. DBMS_SESSION, Oracle PL/SQL Programming
DDL statements: (see DDL)
DML statements: (see DML statements)
I/O-intensive: 25.3.6. Use PL/SQL to Improve Performance of IO-Intensive SQL, Oracle PL/SQL Programming
PL/SQL in: (see stored functions, PL/SQL)
PL/SQL loops versus: 7.7.4. PL/SQL Loops Versus SQL Processing, Oracle PL/SQL Programming
calling functions in: 1.6.5. Calling Packaged Functions in SQL, Advanced Oracle PL/SQL Programming with Packages
calliong PL/SQL functions in: 25.3.2. Call PL/SQL Functions in SQL to Reduce I/O, Oracle PL/SQL Programming
client-side: 25.3.3. Avoid Client-Side SQL, Oracle PL/SQL Programming
dynamic
C.14. DBMS_SQL, Oracle PL/SQL Programming
1.4.4.2. Support for DDL and dynamic SQL, Oracle PL/SQL Programming
formatting statements: 3.2. Formatting SQL Statements, Oracle PL/SQL Programming
minimizing access to: 25.3.1. Use Package Data to Minimize SQL Access, Oracle PL/SQL Programming
statements, recursive processing in: 17.8.7. Recursive Processing in a SQL Statement, Oracle PL/SQL Programming
static vs. dynamic: 6.2.1. Types of Cursors, Oracle PL/SQL Programming
storing functions in: 1.4.4.1. Stored functions in SQL, Oracle PL/SQL Programming
viewing stored objects: 23.6. Using SQL to Examine Stored Objects, Oracle PL/SQL Programming
SQL %FOUND attribute: 6.9.5. Implicit SQL Cursor Attributes, Oracle PL/SQL Programming
SQL %ISOPEN attribute: 6.9.5. Implicit SQL Cursor Attributes, Oracle PL/SQL Programming
SQL %NOTFOUND attribute: 6.9.5. Implicit SQL Cursor Attributes, Oracle PL/SQL Programming
SQL %ROWCOUNT attribute: 6.9.5. Implicit SQL Cursor Attributes, Oracle PL/SQL Programming
SQL Navigator: 6.4. PL/SQL Tools, Oracle Web Applications
SQL Programmer: 6.4. PL/SQL Tools, Oracle Web Applications
SQL Station: 6.4. PL/SQL Tools, Oracle Web Applications
SQL function codes: 2.3.10.4. The DBMS_SQL.LAST_SQL_FUNCTION_CODE function, Oracle Built-in Packages
SQL language
building applications on: 1.2. What Are the Types and Layers of Packages?, Advanced Oracle PL/SQL Programming with Packages
SQL statements
(see also DDL statements; DML statements; long SQL statements)
1.6.1.5. Isolate volatile areas of functionality, Advanced Oracle PL/SQL Programming with Packages
2.2.6. DBMS_SQL Nonprogram Elements, Oracle Built-in Packages
combining into one program: 2.4.3. Combining Operations, Oracle Built-in Packages
constructing: 2.3.4. Binding Values into Dynamic SQL, Oracle Built-in Packages
binding versus concatenation
2.3.4. Binding Values into Dynamic SQL, Oracle Built-in Packages
2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
executing: 2.3.1. Processing Flow of Dynamic SQL, Oracle Built-in Packages
function codes: 2.3.10.4. The DBMS_SQL.LAST_SQL_FUNCTION_CODE function, Oracle Built-in Packages
functions, invoking: 1.3.7.1. Calling a packaged function in SQL, Oracle Built-in Packages
parsing
2.3.1. Processing Flow of Dynamic SQL, Oracle Built-in Packages
2.3.3. Parsing the SQL Statement, Oracle Built-in Packages
deferred: 2.3.3.1. The DBMS_SQL.PARSE procedure, Oracle Built-in Packages
error position in: 2.3.10.1. The DBMS_SQL.LAST_ERROR_POSITION function, Oracle Built-in Packages
language version: 2.2.6. DBMS_SQL Nonprogram Elements, Oracle Built-in Packages
performance improvement: 2.4.5. Improving the Performance of Dynamic SQL, Oracle Built-in Packages
procedures, calling: 1.3.7.2. Using a packaged procedure from within SQL, Oracle Built-in Packages
SQL tracing, reasons for using: 7.3.8. Session Monitoring and Three-Tier Architectures, Oracle Built-in Packages
SQL%BULK_ROWCOUNT cursor attribute
5.2.2. ROLLBACK Behavior with FORALL, Guide to Oracle8i Features
5.4. Using Cursor Attributes, Guide to Oracle8i Features
SQL*Net
2.2.3. The HyperText Transfer Protocol (HTTP), Oracle Web Applications
2.5.5. Additional Security Precautions, Oracle Web Applications
SQL*Object Builder: 6.4. PL/SQL Tools, Oracle Web Applications
SQL*Plus
1.3.7. Fine-Grained Access Control (Chapter 8, Deploying Fine-Grained Access Control), Guide to Oracle8i Features
3.1.1. The Advantages of Definer Rights, Guide to Oracle8i Features
compiling code in: 15.1. Compiling PL/SQL Code in SQL*Plus, Advanced Oracle PL/SQL Programming with Packages
help script: 17.5.4. Building a SQL*Plus Help Script, Advanced Oracle PL/SQL Programming with Packages
initializing: 4.4.2. A PL/Vision Initialization Script for SQL*Plus, Advanced Oracle PL/SQL Programming with Packages
managing stored objects: 23.5. Managing Stored Objects with SQL*Plus, Oracle PL/SQL Programming
scripts included on disk: 4.6. Summary of Files on Disk, Advanced Oracle PL/SQL Programming with Packages
viewing compilation errors: 23.5.4. Viewing Compilation Errors in SQL*Plus, Oracle PL/SQL Programming
SQL/Expediter: 6.4. PL/SQL Tools, Oracle Web Applications
SQL99 compliance
1.3.9. Miscellaneous New Features and Performance Improvements (Chapter 10, More Goodies for Oracle8i PL/SQL Developers), Guide to Oracle8i Features
10.3. SQL99 Compliance, Guide to Oracle8i Features
SQLCODE
UTL_FILE and: 6.2.6.1. Handling file I/O errors, Oracle Built-in Packages
exception types and: 1.3.4. Exception Handling and Built-in Packages, Oracle Built-in Packages
SQLCODE function
6.2.1.3. Trapping system errors, Guide to Oracle8i Features
8.3.1. Named System Exceptions , Oracle PL/SQL Programming
8.6.3. Using SQLCODE and SQLERRM in WHEN OTHERS Clause, Oracle PL/SQL Programming
13.3.5. The SQLCODE function, Oracle PL/SQL Programming
SQLERRM
LAST_ERROR_POSITION and: 2.3.10.1. The DBMS_SQL.LAST_ERROR_POSITION function, Oracle Built-in Packages
UTL_FILE and: 6.2.6.1. Handling file I/O errors, Oracle Built-in Packages
exception types and: 1.3.4. Exception Handling and Built-in Packages, Oracle Built-in Packages
SQLERRM function
6.4.2. Obtaining the Error Message, Advanced Oracle PL/SQL Programming with Packages
8.6.3. Using SQLCODE and SQLERRM in WHEN OTHERS Clause, Oracle PL/SQL Programming
13.3.6. The SQLERRM function, Oracle PL/SQL Programming
SQLJ
1.1. What's in Oracle8i Release 8.1?, Guide to Oracle8i Features
1.3.7. Java, Oracle Web Applications
SQL_TRACE utility: 25.1. Analyzing Program Performance, Oracle PL/SQL Programming
SQL_string
EXECUTE IMMEDIATE statment: 4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features
OPEN FOR statement: 4.2.2. The OPEN FOR Statement, Guide to Oracle8i Features
SQRT function: 13.1.19. The SQRT function, Oracle PL/SQL Programming
SSL (Secure Sockets Layer): 2.5.5. Additional Security Precautions, Oracle Web Applications
STANDARD package
1.1. What Is a PL/SQL Package?, Advanced Oracle PL/SQL Programming with Packages
1.4.1. The STANDARD Package, Oracle Built-in Packages
8.3.1. Named System Exceptions , Oracle PL/SQL Programming
pinning in SGA shared pool: 25.2.2.1. Candidates for pinning in the shared pool, Oracle PL/SQL Programming
STARTUP 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
START_PROFILER function, DBMS_PROFILER package: 7.1.1. DBMS_PROFILER Programs, Guide to Oracle8i Features
START_QUEUE procedure
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.2.2. The DBMS_AQADM.START_QUEUE procedure, Oracle Built-in Packages
C.3.2.6. The START_QUEUE procedure, Oracle PL/SQL Programming
START_TIME_MANAGER procedure
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.7.1. The DBMS_AQADM.START_TIME_MANAGER procedure, Oracle Built-in Packages
STATUS_LINE procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications
STEP syntax: (see numeric FOR loops)
STEP_ID function
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.7.2. The DBMS_TRANSACTION.STEP_ID function, Oracle Built-in Packages
C.15.18. The STEP_ID function, Oracle PL/SQL Programming
STOP_PROFILER function, DBMS_PROFILER package: 7.1.1. DBMS_PROFILER Programs, Guide to Oracle8i Features
STOP_QUEUE procedure
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.4.1. The DBMS_AQADM.STOP_QUEUE procedure, Oracle Built-in Packages
C.3.2.7. The STOP_QUEUE procedure, Oracle PL/SQL Programming
STOP_TIME_MANAGER procedure
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.7.2. The DBMS_AQADM.STOP_TIME_MANAGER procedure, Oracle Built-in Packages
STORAGE_ERROR exception: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming
STORE_VALUES procedure, OWA_OPT_LOCK package: 7.3.2.2. Procedures and functions, Oracle Web Applications
STREAM2MULTI, OWA_TEXT package: 7.2.1.2. Procedures, Oracle Web Applications
SUBMIT procedure
13.1.1. DBMS_JOB Programs, Oracle Built-in Packages
13.2.5.1. The DBMS_JOB.SUBMIT procedure, Oracle Built-in Packages
C.5.8. The SUBMIT procedure, Oracle PL/SQL Programming
SUBSTR function
A.2.5. Builtin Functions, Advanced Oracle PL/SQL Programming with Packages
10.1.3.4. nth_atomic function, Advanced Oracle PL/SQL Programming with Packages
8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.2.4. The DBMS_LOB.SUBSTR function, Oracle Built-in Packages
9.2.3.14. The UTL_RAW.SUBSTR function, Oracle Built-in Packages
C.6.14. The SUBSTR function, Oracle PL/SQL Programming
11.1.14. The SUBSTR function, Oracle PL/SQL Programming
READ versus
8.3.2.3. The DBMS_LOB.READ procedure, Oracle Built-in Packages
8.3.2.4. The DBMS_LOB.SUBSTR function, Oracle Built-in Packages
for declaring long strings: 4.2.3.1. The CHAR datatype, Oracle PL/SQL Programming
SUBTRACT procedure
14.2.1. Getting Started with DBMS_REFRESH, Oracle Built-in Packages
14.2.3.2. The DBMS_REFRESH.SUBTRACT procedure, Oracle Built-in Packages
SUCCESS return code, DBMS_PROFILER package: 7.1.4. Profiler Return Codes, Guide to Oracle8i Features
SUSPEND_MASTER_ACTIVITY procedure
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.7.1. The DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY procedure, Oracle Built-in Packages
SWITCH statements: 6.2.3. Conditionals, Oracle Web Applications
SWITCH_SNAPSHOT_MASTER procedure
14.4.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
14.4.6.1. The DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER procedure, Oracle Built-in Packages
SYS schema: 7.3.1. Installing DBMS_RLS, Guide to Oracle8i Features
SYSDATE function: 12.1.7. The SYSDATE function, Oracle PL/SQL Programming
and NEW_TIME function: 12.2.2. Using NEW_TIME in Client-Server Environments, Oracle PL/SQL Programming
SYSEVENT attribute, database-level event
6.2. Database-Level Event Triggers, Guide to Oracle8i Features
6.3. Schema-Level Event Triggers, Guide to Oracle8i Features
SYS_CONTEXT function
8.1. FGAC Components, Guide to Oracle8i Features
8.4. SYS_CONTEXT and LIST_CONTEXT: Obtaining Context Information, Guide to Oracle8i Features
SYS_NC_OID$ column: 18.4.2.1. Object identifiers (OIDs), Oracle PL/SQL Programming
SYS_NC_ROWINFO$ column: 18.4.2.1. Object identifiers (OIDs), Oracle PL/SQL Programming
Savant Corporation: About Q, Oracle Built-in Packages
Secure Sockets Layer (SSL): 2.5.5. Additional Security Precautions, Oracle Web Applications
Sparc: 1.2.2.2. Developers must know too many platforms, Oracle Web Applications
Study Conduction, Institute for: 1.3.5. Encapsulating Access to the Built-in Packages, Oracle Built-in Packages
Sybase Transact-SQL: 1.2. And Then There's Java, Guide to Oracle8i Features
Symantec Visual Page: 1.3.9.2. Multimedia data, Oracle Web Applications
System Global Area (SGA)
(see also SGA)
pinning critical code into: 25.2.2. Pin Critical Code into the SGA, Oracle PL/SQL Programming
4.4.1. Binding Versus Concatenation, Guide to Oracle8i Features
tuning shared pool size: 25.2.1. Tune the Size of the Shared Pool of the SGA, Oracle PL/SQL Programming
sale package
(see also specific program names)
5.7.6. Using Time Delay and Expiration, Oracle Built-in Packages
save procedure: 5.25.7. Saving and restoring settings, Advanced Oracle PL/SQL Programming with Packages
save_message procedure, FORUM package
8.3.6. The FORUM Package, Oracle Web Applications
8.3.6.2. Body, Oracle Web Applications
save_user_info, FORUM_USERS package
8.3.5. The FORUM_USERS Package, Oracle Web Applications
8.3.5.2. Body, Oracle Web Applications
savepoints
(see also ROLLBACK procedure)
20.2.3. Setting Savepoints, Advanced Oracle PL/SQL Programming with Packages
2.4. Rules and Restrictions, Guide to Oracle8i Features
6.1.2. The ROLLBACK Statement, Oracle PL/SQL Programming
COMMIT statements and: 6.1.1. The COMMIT Statement, Oracle PL/SQL Programming
PLVlog: 21.1.5.2. How PLVlog manages the transaction, Advanced Oracle PL/SQL Programming with Packages
creating: 6.1.3. The SAVEPOINT Statement, Oracle PL/SQL Programming
savesrc procedure: 5.15.8. Saving and restoring repository settings, Advanced Oracle PL/SQL Programming with Packages
savetrg procedure: 5.15.8. Saving and restoring repository settings, Advanced Oracle PL/SQL Programming with Packages
saving
PL/SQL objects: 11.3.4. Saving and Restoring the Current Object, Advanced Oracle PL/SQL Programming with Packages
message text: 9.2. Storing Message Text, Advanced Oracle PL/SQL Programming with Packages
repository settings
12.8. Saving and Restoring Settings, Advanced Oracle PL/SQL Programming with Packages
5.15.8. Saving and restoring repository settings, Advanced Oracle PL/SQL Programming with Packages
table settings: 5.25.7. Saving and restoring settings, Advanced Oracle PL/SQL Programming with Packages
viewing stored code: 5.29. PLVvu: Code and Error Viewing , Advanced Oracle PL/SQL Programming with Packages
virtual REFs: 20.4.3. Storage of Virtual REFs, Oracle PL/SQL Programming
saving_src function: 5.15.8. Saving and restoring repository settings, Advanced Oracle PL/SQL Programming with Packages
saving_trg function: 5.15.8. Saving and restoring repository settings, Advanced Oracle PL/SQL Programming with Packages
scalar datatypes: (see datatypes)
scalar values
5.3. Bulk Querying with the BULK COLLECT Clause, Guide to Oracle8i Features
and aggregates: 17.8.2. Combining Scalar and Aggregate Values, Oracle PL/SQL Programming
binding: 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
scale: 4.2.1.2. Decimal numeric datatypes, Oracle PL/SQL Programming
scanning strings: 5.16.2. Scanning PL/SQL strings, Advanced Oracle PL/SQL Programming with Packages
schedule_pkg package
(see also specific program names)
5.7.7.2. Dequeuing messages when part of a group, Oracle Built-in Packages
scheduled links: 17.2.6. Scheduling Propagation (Oracle8 only), Oracle Built-in Packages
scheduling: (see deferred transactions; propagating messages)
scheduling jobs
C.5. DBMS_ JOB, Oracle PL/SQL Programming
1.4.5.3. Job scheduling with DBMS_ JOB, Oracle PL/SQL Programming
schema evolution
object types and: 18.6.3. Schema Evolution, Oracle PL/SQL Programming
object views and
20. Object Views, Oracle PL/SQL Programming
20.6. Schema Evolution, Oracle PL/SQL Programming
schema parameter, CREATE CONTEXT statement: 8.2. CREATE CONTEXT: Creating Contexts, Guide to Oracle8i Features
schema procedure: 5.8.3. Dumping the DDL, Advanced Oracle PL/SQL Programming with Packages
schema-level event triggers
1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
6.2.1.3. Trapping system errors, Guide to Oracle8i Features
6.3. Schema-Level Event Triggers, Guide to Oracle8i Features
schema_name, trigger syntax: 6.3. Schema-Level Event Triggers, Guide to Oracle8i Features
schemas
(see also DDL)
PLVdyn and: 19.5.10. Executing PLVdyn in Different Schemas, Advanced Oracle PL/SQL Programming with Packages
analyzing: 10.1.2.2. The DBMS_UTILITY.ANALYZE_SCHEMA procedure, Oracle Built-in Packages
compiling: 10.1.2.5. The DBMS_UTILITY.COMPILE_SCHEMA procedure, Oracle Built-in Packages
names for, returning: 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages
scope
3.8. Broadening the Scope, Advanced Oracle PL/SQL Programming with Packages
1.6.5. Scoping with nested blocks, Oracle PL/SQL Programming
2.7.2. Scope of a Block, Oracle PL/SQL Programming
15.3.4.2. Nested blocks provide scope, Oracle PL/SQL Programming
cursor: 15.3.5.4. Cursor scope, Oracle PL/SQL Programming
nested blocks and: 15.3.5.2. Scope and nested blocks, Oracle PL/SQL Programming
of cursor parameters: 6.10.3. Scope of Cursor Parameters, Oracle PL/SQL Programming
of cursor variables: 6.12.6.4. Scope of cursor object, Oracle PL/SQL Programming
of exceptions: 8.4.1. Scope of an Exception, Oracle PL/SQL Programming
of local modules: 15.7.5. Scope of Local Modules, Oracle PL/SQL Programming
of loops: 7.6.2. Loop Scope, Oracle PL/SQL Programming
of variables in dynamic SQL
2.4.8. Executing Dynamic PL/SQL, Oracle Built-in Packages
4.6.3. Dynamic PL/SQL , Guide to Oracle8i Features
scripts: (see code)
search engines: 1.2.1.1. Finding what you need, Oracle Web Applications
searching
for help text: 17.5.2. Locating Text in the Data Dictionary, Advanced Oracle PL/SQL Programming with Packages
and replacing text: 7.2.2. OWA_PATTERN: Searching and Replacing Text, Oracle Web Applications
for source code: 15.4.1. How to Find Source Code, Advanced Oracle PL/SQL Programming with Packages
second: (see date; time)
secondary_instance parameter: 7.6.1. Setting Version Compatibility and Queue Migration, Guide to Oracle8i Features
security
1.6.1.5. Isolate volatile areas of functionality, Advanced Oracle PL/SQL Programming with Packages
7.3.1. Installing DBMS_RLS, Guide to Oracle8i Features
7.6.1. CREATE_QUEUE_TABLE and MIGRATE_QUEUE_TABLE: Setting Version Compatibility and Queue Migration, Guide to Oracle8i Features
2.5. Database Security Review, Oracle Web Applications
3.1.1.2. Administer WebDB and database security, Oracle Web Applications
DBMS_PIPE and: 3.1. DBMS_PIPE: Communicating Between Sessions , Oracle Built-in Packages
UTL_FILE and: 6.2.1.3. File security, Oracle Built-in Packages
WebDB: 3.1.1.2. Administer WebDB and database security, Oracle Web Applications
access: (see access)
and PL/SQL cartridge: 4.2.3. Security Issues with the PL/SQL Cartridge, Oracle Web Applications
backups: (see backups)
distinguishing users: 7.2.4.2. Example, Oracle Built-in Packages
encrypting code: 23.7. Encrypting Stored Code, Oracle PL/SQL Programming
examples: 8.2.5. Security Privileges, Oracle Web Applications
managing with OWA_SEC: 7.4.2. OWA_SEC: Managing Security , Oracle Web Applications
system privileges: 2.5.3. Privileges, Oracle Web Applications
transaction integrity: 1.3.5. Guaranteeing Transaction Integrity, Advanced Oracle PL/SQL Programming with Packages
segspace package
(see also specific program names)
1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
12.1.3.1. The segspace package, Oracle Built-in Packages
segspace.sql : 12.1.3.1. The segspace package, Oracle Built-in Packages
select lists: 6.4.2. PL/SQL Variables in a Cursor, Oracle PL/SQL Programming
semicolon (;): 2.4. The Semicolon Delimiter, Oracle PL/SQL Programming
sendto procedure
5.17.3. Selecting the log type, Advanced Oracle PL/SQL Programming with Packages
21.1.3. Selecting the Log Type, Advanced Oracle PL/SQL Programming with Packages
sepchar function: 6.2.6.3. Combining locations and filenames, Oracle Built-in Packages
seq procedure: 5.8.3. Dumping the DDL, Advanced Oracle PL/SQL Programming with Packages
sequence wizard, WebDB: 3.1.2.1. Building database objects, Oracle Web Applications
sequential control structures: 5.2. Sequential Control Statements, Oracle PL/SQL Programming
formatting: 3.3. Formatting Control Structures, Oracle PL/SQL Programming
sequential processing: 17.8.6. Sequential Processing Against a Column's Value, Oracle PL/SQL Programming
serializable isolation level: 6.1.4. The SET TRANSACTION Statement, Oracle PL/SQL Programming
serializing access, DBMS_LOCK and: 4.1. DBMS_LOCK: Creating and Managing Resource Locks, Oracle Built-in Packages
server port parameter, server settings: 3.2.3.1. Server settings, Oracle Web Applications
server procedure: 3.1.7.5. The pipesvr package, Oracle Built-in Packages
server-to-client communications: 2.2. Server-to-Client Communication, Oracle Web Applications
HTTP: 2.2.3. The HyperText Transfer Protocol (HTTP), Oracle Web Applications
TCP/IP networks: 2.2.1. The TCP/IP Network, Oracle Web Applications
URLs: 2.2.5. The Uniform Resource Locator, Oracle Web Applications
communication ports: 2.2.2. The Communication Port, Oracle Web Applications
resource MIME type: 2.2.6. The Resource MIME Type, Oracle Web Applications
web browsers: 2.2.4. The Web Browser, Oracle Web Applications
server_status procedure: 3.1.7.5. The pipesvr package, Oracle Built-in Packages
server_stop procedure: 3.1.7.5. The pipesvr package, Oracle Built-in Packages
servers
2.2.5. The Uniform Resource Locator, Oracle Web Applications
allowing file access to: 13.1.1. Enabling File Access in the Oracle Server , Advanced Oracle PL/SQL Programming with Packages
files: (see files)
PL/SQL integration with (example): 19.7. Example: PL/SQL-to-Server Integration, Oracle PL/SQL Programming
parallel server mode, testing for: 10.1.2.15. The DBMS_UTILITY.IS_PARALLEL_SERVER function, Oracle Built-in Packages
resource management: 12. Managing Server Resources, Oracle Built-in Packages
settings, WebDB: 3.2.3.1. Server settings, Oracle Web Applications
streaming: 1.3.9.2. Multimedia data, Oracle Web Applications
servlets, Java: 1.3.7. Java, Oracle Web Applications
sess1.sql : 11.1.4.3. The DBMS_SESSION.RESET_PACKAGE procedure, Oracle Built-in Packages
sess2.sql : 11.1.5.8. The memory procedure, Oracle Built-in Packages
session labels
setting format: 11.1.2.2. DBMS_SESSION.SET_MLS_LABEL_FORMAT procedure, Oracle Built-in Packages
setting value: 11.1.2.1. The DBMS_SESSION.SET_LABEL procedure, Oracle Built-in Packages
session names, returning unique name: 3.1.3.5. The DBMS_PIPE.UNIQUE_SESSION_NAME function, Oracle Built-in Packages
sessions
action names, returning: 7.2.2. The DBMS_APPLICATION_INFO.READ_MODULE procedure, Oracle Built-in Packages
identifiers for: 11.1.3.2. The DBMS_SESSION.UNIQUE_SESSION_ID function, Oracle Built-in Packages
enhancement
11.1.5.2. The unique_id function, Oracle Built-in Packages
11.1.5.4. The sid function, Oracle Built-in Packages
modifying settings: 11.1.2. Modifying Session Settings, Oracle Built-in Packages
monitoring: (see performance analysis)
obtaining information about: 11.1.3. Obtaining Session Information, Oracle Built-in Packages
enhancement: 11.1.5.3. The load_my_session_rec procedure, Oracle Built-in Packages
program names, returning: 7.2.2. The DBMS_APPLICATION_INFO.READ_MODULE procedure, Oracle Built-in Packages
resource management: 11.1.4. Managing Session Resources, Oracle Built-in Packages
session information: 11.1. DBMS_SESSION: Managing Session Information, Oracle Built-in Packages
settings, job execution and: 13.1.2.2. The what parameter, Oracle Built-in Packages
suspending with SLEEP: 4.1.2.5. The DBMS_LOCK.SLEEP procedure, Oracle Built-in Packages
tracing
another session: 11.2.2.3. The DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure, Oracle Built-in Packages
same session: 11.1.4.5. The DBMS_SESSION.SET_SQL_TRACE procedure, Oracle Built-in Packages
user: 13.3.9. The USERENV function, Oracle PL/SQL Programming
set_author procedure
5.13.3. Setting the author, Advanced Oracle PL/SQL Programming with Packages
16.3.2. Setting the Code Author, Advanced Oracle PL/SQL Programming with Packages
set_context procedure: 22.3.3.2. Setting the context, Advanced Oracle PL/SQL Programming with Packages
set_current_row procedure: 7.3.9. Tracking Long-Running Processes, Oracle Built-in Packages
set_datemask function: 6.2. Setting the PL/Vision Date Mask, Advanced Oracle PL/SQL Programming with Packages
set_datemask procedure: 5.3.3. Setting the date format mask, Advanced Oracle PL/SQL Programming with Packages
set_dbtab procedure
5.17.6. Managing the log , Advanced Oracle PL/SQL Programming with Packages
21.1.3.1. Defining the database log table, Advanced Oracle PL/SQL Programming with Packages
set_delim procedure
5.11.3. Setting the operating system delimiter, Advanced Oracle PL/SQL Programming with Packages
13.2.1. Setting the Operating System Delimiter, Advanced Oracle PL/SQL Programming with Packages
set_dir procedure
5.11.4. Setting the default directory or location, Advanced Oracle PL/SQL Programming with Packages
13.2.2. Setting the Default Directory, Advanced Oracle PL/SQL Programming with Packages
set_factor procedure
5.27.3. Setting the factoring value, Advanced Oracle PL/SQL Programming with Packages
14.3.3. Setting the Timing Factor, Advanced Oracle PL/SQL Programming with Packages
set_id_default procedure
5.12.2. Setting the PLVfk configuration, Advanced Oracle PL/SQL Programming with Packages
19.6.2.1. Setting column name defaults, Advanced Oracle PL/SQL Programming with Packages
set_indent procedure: 16.3.1. Indentation in PLVgen, Advanced Oracle PL/SQL Programming with Packages
set_line_limit procedure
5.15.5. Managing the source WHERE clause, Advanced Oracle PL/SQL Programming with Packages
12.4.3. Setting a Line Limit, Advanced Oracle PL/SQL Programming with Packages
set_linesep procedure
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
set_name procedure: 11.3.1. Setting Individual Elements of Current Object, Advanced Oracle PL/SQL Programming with Packages
set_nm_default procedure
5.12.2. Setting the PLVfk configuration, Advanced Oracle PL/SQL Programming with Packages
19.6.2.1. Setting column name defaults, Advanced Oracle PL/SQL Programming with Packages
set_nullval function: 6.1. Null Substitution Value, Advanced Oracle PL/SQL Programming with Packages
set_nullval procedure: 5.3.4. Setting the NULL substitution value, Advanced Oracle PL/SQL Programming with Packages
set_object procedure: 15.4.1. How to Find Source Code, Advanced Oracle PL/SQL Programming with Packages
set_overlap procedure
5.29.2. Setting the overlap, Advanced Oracle PL/SQL Programming with Packages
15.2.2. Setting the Code Overlap, Advanced Oracle PL/SQL Programming with Packages
set_pagesize procedure
5.14.2. Setting the page size, Advanced Oracle PL/SQL Programming with Packages
17.4.2. Setting the Page Size, Advanced Oracle PL/SQL Programming with Packages
set_prefix procedure
5.2.3. Setting the line prefix, Advanced Oracle PL/SQL Programming with Packages
5.25.6. Setting the row prefix, Advanced Oracle PL/SQL Programming with Packages
7.3. The Output Prefix , Advanced Oracle PL/SQL Programming with Packages
8.5. Setting the Display Prefix, Advanced Oracle PL/SQL Programming with Packages
set_repeats procedure: 5.27.2. Setting the repetition value, Advanced Oracle PL/SQL Programming with Packages
set_row procedure: 7.3.9. Tracking Long-Running Processes, Oracle Built-in Packages
set_savepoint procedure
5.23.4. Managing savepoints , Advanced Oracle PL/SQL Programming with Packages
20.2.3. Setting Savepoints, Advanced Oracle PL/SQL Programming with Packages
set_schema procedure: 11.3.1. Setting Individual Elements of Current Object, Advanced Oracle PL/SQL Programming with Packages
set_segment procedure: 12.1.3.1. The segspace package, Oracle Built-in Packages
set_sp procedure
5.17.7. Rolling back in PLVlog, Advanced Oracle PL/SQL Programming with Packages
21.1.5.7. Setting the post-insert savepoint, Advanced Oracle PL/SQL Programming with Packages
set_sql_trace procedure
11.1.5.1. Adding value to DBMS_SESSION, Oracle Built-in Packages
11.1.5.6. The set_sql_trace procedure, Oracle Built-in Packages
set_srcwhere procedure
5.15.5. Managing the source WHERE clause, Advanced Oracle PL/SQL Programming with Packages
12.4.2. Changing the WHERE Clause , Advanced Oracle PL/SQL Programming with Packages
set_stats procedure: 7.3.3. The set_stats Procedure, Oracle Built-in Packages
set_trace procedure: 11.2.3. DBMS_SYSTEM Examples, Oracle Built-in Packages
set_type procedure: 11.3.1. Setting Individual Elements of Current Object, Advanced Oracle PL/SQL Programming with Packages
set_vclen procedure
5.12.2. Setting the PLVfk configuration, Advanced Oracle PL/SQL Programming with Packages
19.6.2.2. Setting the default string length, Advanced Oracle PL/SQL Programming with Packages
setcase script: 18.1.2. A Script to Convert Programs, Advanced Oracle PL/SQL Programming with Packages
setcurr procedure: 11.3. Setting the Current Object, Advanced Oracle PL/SQL Programming with Packages
setpath procedure: 6.2.6.4. Adding support for paths, Oracle Built-in Packages
setsepchar procedure: 6.2.6.3. Combining locations and filenames, Oracle Built-in Packages
setsrc procedure
5.15.4. Managing the source repository, Advanced Oracle PL/SQL Programming with Packages
12.2.1. String Source or Target, Advanced Oracle PL/SQL Programming with Packages
12.3.1. Setting the Source, Advanced Oracle PL/SQL Programming with Packages
12.3.3. Using setsrc and initsrc, Advanced Oracle PL/SQL Programming with Packages
settrg procedure
5.15.6. Managing the target repository, Advanced Oracle PL/SQL Programming with Packages
12.5. Managing the Target Repository, Advanced Oracle PL/SQL Programming with Packages
setup.exe file: 4.3.3. Beginning the Installation, Advanced Oracle PL/SQL Programming with Packages
shared
functions: 23.1.2. Executing Functions, Oracle PL/SQL Programming
procedures: 23.1.1. Executing Procedures, Oracle PL/SQL Programming
libraries:
1.4.7.5. External procedures, Oracle PL/SQL Programming
3.1.2.3. Building shared components, Oracle Web Applications
for external procedures: 21.2.2. Step 2: Identify or Create the Shared Library, Oracle PL/SQL Programming
memory: (see memory)
pool
(see also pipes)
3.1. DBMS_PIPE: Communicating Between Sessions , Oracle Built-in Packages
12.2. DBMS_SHARED_POOL: Pinning Objects, Oracle Built-in Packages
memory freed and: 11.1.4.2. The DBMS_SESSION.FREE_UNUSED_USER_MEMORY procedure, Oracle Built-in Packages
pinning
cursors: 12.2.4.2. Pinning cursors into the shared pool, Oracle Built-in Packages
objects: 12.2.2.1. The DBMS_SHARED_POOL.KEEP procedure, Oracle Built-in Packages
packages at startup (example): 12.2.4.1. Pinning packages automatically, Oracle Built-in Packages
SGA: 25.2.1. Tune the Size of the Shared Pool of the SGA, Oracle PL/SQL Programming
size information
12.2.3.1. The DBMS_SHARED_POOL.SIZES procedure, Oracle Built-in Packages
12.2.4.3. The DBA_KEEPSIZES view, Oracle Built-in Packages
size threshold: 12.2.3.2. The DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD procedure, Oracle Built-in Packages
unpinning objects: 12.2.2.2. The DBMS_SHARED_POOL.UNKEEP procedure, Oracle Built-in Packages
sharing PL/Vision: 4.3.6. Granting Access to PL/Vision, Advanced Oracle PL/SQL Programming with Packages
show function: 5.28.7. Displaying an activity trace, Advanced Oracle PL/SQL Programming with Packages
show procedure
17.4.1. Showing the Help Text, Advanced Oracle PL/SQL Programming with Packages
17.5.5. Constructing an Online Help Package, Advanced Oracle PL/SQL Programming with Packages
21.2.3. Tracing Code Execution, Advanced Oracle PL/SQL Programming with Packages
22.1.7.2. Showing errors, Advanced Oracle PL/SQL Programming with Packages
2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages
showCol program, ndsutil.pkg file: 4.7. NDS Utility Package, Guide to Oracle8i Features
show_by_group procedure: 5.7.7.2. Dequeuing messages when part of a group, Oracle Built-in Packages
show_changers_to procedure: 5.7.8.1. Using the subscriber list, Oracle Built-in Packages
show_elapsed procedure
5.27.5. Retrieving and displaying elapsed time, Advanced Oracle PL/SQL Programming with Packages
14.3.2. show_elapsed Procedure, Advanced Oracle PL/SQL Programming with Packages
show_expired_sales procedure: 5.7.6. Using Time Delay and Expiration, Oracle Built-in Packages
show_name_components procedure: 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages
show_string procedure: 5.6.3. Other functions and procedures, Advanced Oracle PL/SQL Programming with Packages
show_table procedure: 5.6.3. Other functions and procedures, Advanced Oracle PL/SQL Programming with Packages
showargs procedure: 10.2.3.1. Features of the psdesc package, Oracle Built-in Packages
showattr.sql file: 5.4. Using Cursor Attributes, Guide to Oracle8i Features
showblk procedure: 5.25.5. Toggle for showing blanks in row, Advanced Oracle PL/SQL Programming with Packages
showcomp.sp : 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages
showcurr procedure
5.20.4. Accessing the current object, Advanced Oracle PL/SQL Programming with Packages
11.3.3. Displaying the Current Object, Advanced Oracle PL/SQL Programming with Packages
showecs procedure
5.28.8. Accessing the PLVtrc execution call stack (ECS), Advanced Oracle PL/SQL Programming with Packages
21.2.4.6. Displaying the stack, Advanced Oracle PL/SQL Programming with Packages
showemps.sp : 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure, Oracle Built-in Packages
showerr procedure: (see err procedure)
showhdr procedure: 5.25.3. Toggle for showing header, Advanced Oracle PL/SQL Programming with Packages
showhelp procedure: 17.5.4. Building a SQL*Plus Help Script, Advanced Oracle PL/SQL Programming with Packages
showing function
5.9.1. Tracing PLVdyn activity, Advanced Oracle PL/SQL Programming with Packages
19.5.9. Tracing Use of Dynamic SQL, Advanced Oracle PL/SQL Programming with Packages
22.1.7.2. Showing errors, Advanced Oracle PL/SQL Programming with Packages
showing_header function: 5.25.3. Toggle for showing header, Advanced Oracle PL/SQL Programming with Packages
showing_row function: 5.25.4. Toggle for showing row numbers, Advanced Oracle PL/SQL Programming with Packages
showlog.sql script: 21.1.4.2. Retrieving log data from PL/SQL table, Advanced Oracle PL/SQL Programming with Packages
showmsgs procedure: 5.7.1. Improving AQ Ease of Use, Oracle Built-in Packages
showrow procedure: 5.25.4. Toggle for showing row numbers, Advanced Oracle PL/SQL Programming with Packages
showsql procedure
5.9.1. Tracing PLVdyn activity, Advanced Oracle PL/SQL Programming with Packages
19.5.9. Tracing Use of Dynamic SQL, Advanced Oracle PL/SQL Programming with Packages
showsubs.sp : 5.5.3.3. The DBMS_AQADM.QUEUE_SUBSCRIBERS procedure, Oracle Built-in Packages
showsubs.sql : 5.5.3.3. The DBMS_AQADM.QUEUE_SUBSCRIBERS procedure, Oracle Built-in Packages
shutting down programs: 22.1.10. Bailing Out with PLVexc, Advanced Oracle PL/SQL Programming with Packages
sid function: 11.1.5.4. The sid function, Oracle Built-in Packages
signatures: 6.1.5. Overloading, Oracle Web Applications
signed numbers
4.2.1.1. Binary integer datatypes, Oracle PL/SQL Programming
4.2.1.3. The PLS_INTEGER datatype, Oracle PL/SQL Programming
simple loops
6.2.4. Loops, Oracle Web Applications
7.2. The Simple Loop, Oracle PL/SQL Programming
formatting: 3.3.2. Formatting Loops, Oracle PL/SQL Programming
single-character substitution (_): 5.7.5.1. Wildcarded correlation identifiers, Oracle Built-in Packages
site administrator, WebDB: 3.1.3.3. Controlling access to content, Oracle Web Applications
site priority groups: 16.4. Site Priority Groups with DBMS_REPCAT, Oracle Built-in Packages
adding sites: 16.4.3.1. The DBMS_REPCAT.ADD_SITE_PRIORITY_SITE procedure, Oracle Built-in Packages
altering site priority: 16.4.3.3. The DBMS_REPCAT.ALTER_SITE_PRIORITY procedure, Oracle Built-in Packages
altering sites by name: 16.4.3.4. The DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE, Oracle Built-in Packages
comments, creating or changing: 16.4.2.3. The DBMS_REPCAT.COMMENT_ON_SITE_PRIORITY procedure, Oracle Built-in Packages
concepts: 16.4.1. About Site Priority Groups, Oracle Built-in Packages
creating: 16.4.2.1. The DBMS_REPCAT.DEFINE_SITE_PRIORITY procedure, Oracle Built-in Packages
dropping site priorities by priority level: 16.4.3.2. The DBMS_REPCAT.DROP_SITE_PRIORITY_SITE procedure, Oracle Built-in Packages
dropping site priority groups: 16.4.2.2. The DBMS_REPCAT.DROP_SITE_PRIORITY procedure, Oracle Built-in Packages
dropping sites by name: 16.4.3.2. The DBMS_REPCAT.DROP_SITE_PRIORITY_SITE procedure, Oracle Built-in Packages
size
SGA shared pool, tuning: 25.2.1. Tune the Size of the Shared Pool of the SGA, Oracle PL/SQL Programming
database triggers: 25.3.7. Keep Database Triggers Small, Oracle PL/SQL Programming
encrypted code file size: 23.7.3. Impact of Encrypting Code, Oracle PL/SQL Programming
message text: 9.5.1. Using PLVmsg in PL/Vision , Advanced Oracle PL/SQL Programming with Packages
of PL/SQL code, analyzing: 23.6.3. Analyzing the Size of PL/SQL Code, Oracle PL/SQL Programming
online documentation page
17.4.2. Setting the Page Size, Advanced Oracle PL/SQL Programming with Packages
17.5.6.4. Maintaining the current page variables, Advanced Oracle PL/SQL Programming with Packages
online help page: 5.14.2. Setting the page size, Advanced Oracle PL/SQL Programming with Packages
package: 1.6.4. Working with Large Packages, Advanced Oracle PL/SQL Programming with Packages
source WHERE clause: 12.4.3. Setting a Line Limit, Advanced Oracle PL/SQL Programming with Packages
slicing and dicing byte strings: 9.2.2.2. Slicing and dicing, Oracle Built-in Packages
smart_job procedure: 13.4.3. Self-Modifying and Self-Aware Jobs, Oracle Built-in Packages
snapshot groups
adding snapshots: 14.2.3.1. The DBMS_REFRESH.ADD procedure, Oracle Built-in Packages
changing properties: 14.2.4. Altering Properties of a Snapshot Group, Oracle Built-in Packages
creating: 14.2.2.1. The DBMS_REFRESH.MAKE procedure, Oracle Built-in Packages
destroying: 14.2.2.2. The DBMS_REFRESH.DESTROY procedure, Oracle Built-in Packages
dropping all snapshots and snapshot groups: 14.2.2.1. The DBMS_REFRESH.MAKE procedure, Oracle Built-in Packages
refreshing: 14.2.5. Manually Refreshing Snapshot Groups, Oracle Built-in Packages
subtracting snapshots: 14.2.3.2. The DBMS_REFRESH.SUBTRACT procedure, Oracle Built-in Packages
snapshot logs
fast refresh and: 14.1.3.1. The DBMS_SNAPSHOT.REFRESH procedure, Oracle Built-in Packages
master site switching and: 14.4.6.1. The DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER procedure, Oracle Built-in Packages
purging: 14.1.4. Purging the Snapshot Log, Oracle Built-in Packages
snapshot replication groups
adding objects to: 14.4.3.1. The DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT procedure, Oracle Built-in Packages
creating: 14.4.2.1. The DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP procedure, Oracle Built-in Packages
dropping: 14.4.2.3. The DBMS_REPCAT.DROP_SNAPSHOT_REPGROUP procedure, Oracle Built-in Packages
dropping objects from: 14.4.3.2. The DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT procedure, Oracle Built-in Packages
propagation mode alteration: 14.4.4. Altering a Snapshot Replication Group's Propagation Mode, Oracle Built-in Packages
refreshing: 14.4.5. Manually Refreshing a Snapshot Replication Group, Oracle Built-in Packages
switching master site: 14.4.6.1. The DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER procedure, Oracle Built-in Packages
snapshot site: 1.3.8. InternetLite, Oracle Web Applications
snapshot_too_old exception: 5.10.2. Package-based exceptions, Advanced Oracle PL/SQL Programming with Packages
snapshots: C.13. DBMS_SNAPSHOT, Oracle PL/SQL Programming
beginning import: 14.3.2.1. The DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD procedure, Oracle Built-in Packages
dropping all snapshots and snapshot groups: 14.2.2.1. The DBMS_REFRESH.MAKE procedure, Oracle Built-in Packages
droppping replication groups and: 15.3.2.2. The DBMS_REPCAT.DROP_MASTER_REPGROUP procedure, Oracle Built-in Packages
ending import: 14.3.2.2. The DBMS_OFFLINE_SNAPSHOT.END_LOAD procedure, Oracle Built-in Packages
export/import (loading): 14.3.2. DBMS_OFFLINE_SNAPSHOT Interface, Oracle Built-in Packages
instantiation
14.3. DBMS_OFFLINE_SNAPSHOT: Performing Offline Snapshot Instantiation, Oracle Built-in Packages
14.4.2.2. The offline snapshot instantiation procedure, Oracle Built-in Packages
refresh state: 14.1.2.1. The DBMS_SNAPSHOT.I_AM_A_REFRESH function, Oracle Built-in Packages
refreshing: 14.1.3. Refreshing Snapshots, Oracle Built-in Packages
rollback and: 14.1.3.1. The DBMS_SNAPSHOT.REFRESH procedure, Oracle Built-in Packages
registering: 14.1.6. Registering Snapshots, Oracle Built-in Packages
unregistering: 14.1.6.2. The DBMS_SNAPSHOT.UNREGISTER_SNAPSHOT procedures (Oracle8 only), Oracle Built-in Packages
software: (see code)
software development kit (SDK): 3.1.2.4. Building custom components, Oracle Web Applications
software port: 2.2.2. The Communication Port, Oracle Web Applications
software usage meter
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
sort order (NLS), setting: 11.1.2.3. The DBMS_SESSION.SET_NLS procedure, Oracle Built-in Packages
source WHERE clause: 12.4. The Source WHERE Clause, Advanced Oracle PL/SQL Programming with Packages
source code (see code)
source repository
5.15.3. Source and target repository type functions, Advanced Oracle PL/SQL Programming with Packages
12.3. Managing the Source Repository, Advanced Oracle PL/SQL Programming with Packages
12.6. Reading From the Source, Advanced Oracle PL/SQL Programming with Packages
12.9.1. Closing the Source, Advanced Oracle PL/SQL Programming with Packages
sp_timer package
1.6.2. The Package Body, Advanced Oracle PL/SQL Programming with Packages
14. PLVtmr: Analyzing Program Performance, Advanced Oracle PL/SQL Programming with Packages
space: (see memory)
deallocating unused space: 12.1.2.2. The DBMS_SPACE.UNUSED_SPACE procedure, Oracle Built-in Packages
freelist blocks available: 12.1.2.1. The DBMS_SPACE.FREE_BLOCKS procedure, Oracle Built-in Packages
unused space information: 12.1.2.2. The DBMS_SPACE.UNUSED_SPACE procedure, Oracle Built-in Packages
utilization information: 12.1. DBMS_SPACE: Obtaining Space Information, Oracle Built-in Packages
space, temporary LOBs: 7.5.2. DBMS_LOB: Working with Temporary LOBs, Guide to Oracle8i Features
space_logger procedure: 13.4.1. Tracking Space in Tablespaces, Oracle Built-in Packages
spaces: (see whitespace)
sparsity of tables
10.2. Characteristics of PL/SQL Tables, Oracle PL/SQL Programming
10.9.2. Data-Smart Row Numbers in PL/SQL Tables, Oracle PL/SQL Programming
spcex1.sql : 12.1.2.2. The DBMS_SPACE.UNUSED_SPACE procedure, Oracle Built-in Packages
spcex2.sql : 12.1.3.1. The segspace package, Oracle Built-in Packages
special characters (NLS), setting: 11.1.2.3. The DBMS_SESSION.SET_NLS procedure, Oracle Built-in Packages
specifications, package
1.7.3. Center All Development Around Packages, Oracle PL/SQL Programming
1.4.1. The Package Specification, Advanced Oracle PL/SQL Programming with Packages
1.6. Building Packages, Advanced Oracle PL/SQL Programming with Packages
(see packages, specification)
speed: (see performance)
sptimer.spb : 10.1.2.14. The DBMS_UTILITY.GET_TIME function, Oracle Built-in Packages
sptimer.sps : 10.1.2.14. The DBMS_UTILITY.GET_TIME function, Oracle Built-in Packages
sql_statement, FORALL statement: 5.2. Bulk DML with the FORALL Statement, Guide to Oracle8i Features
sqlarea.sql : 7.3.7. Monitoring Application SQL Resource Consumption, Oracle Built-in Packages
square brackets ([ ]): 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
src2trg procedure
5.15.9. Miscellaneous PLVio programs, Advanced Oracle PL/SQL Programming with Packages
12.7.2. Batch Transfer of Source to Target, Advanced Oracle PL/SQL Programming with Packages
srcselect function
5.15.4. Managing the source repository, Advanced Oracle PL/SQL Programming with Packages
12.4.1. Viewing the Current Source SELECT, Advanced Oracle PL/SQL Programming with Packages
stacks
(see also call stack; error stack)
PL/SQL call: 21.2.2. Accessing the PL/SQL Call Stack, Advanced Oracle PL/SQL Programming with Packages
5.24. PLVstk: Stack Manager, Advanced Oracle PL/SQL Programming with Packages
5.28.5. Accessing the PL/SQL call stack, Advanced Oracle PL/SQL Programming with Packages
10.1.2.11. The DBMS_UTILITY.FORMAT_ERROR_STACK function, Oracle Built-in Packages
AQ example: 5.7.3. Building a Stack with AQ Using Sequence Deviation, Oracle Built-in Packages
ECS: 5.28.8. Accessing the PLVtrc execution call stack (ECS), Advanced Oracle PL/SQL Programming with Packages
PLVtrc execution: 21.2.4. The PLVtrc Program Stack, Advanced Oracle PL/SQL Programming with Packages
standalone
elements, bundling into packages: 1.6.1.1. Clean up a bewildering mass of standalone functions and procedures, Advanced Oracle PL/SQL Programming with Packages
procedures
23.2.2. Creating Synonyms for Stored Objects, Oracle PL/SQL Programming
17.3.2.2. The DBMS_DEFER.CALL procedure, Oracle Built-in Packages
standard output: 12.2.5. Standard Output Target, Advanced Oracle PL/SQL Programming with Packages
standard system exceptions
1.3.4. Exception Handling and Built-in Packages, Oracle Built-in Packages
1.3.4.3. Standard system exception, Oracle Built-in Packages
standard.sql file: 1.4.1. The STANDARD Package, Oracle Built-in Packages
standards, coding: 4.1.1. The Benefits of PL/Vision, Advanced Oracle PL/SQL Programming with Packages
start time (timer): 14.2. Capturing the Start Time, Advanced Oracle PL/SQL Programming with Packages
startcmnt function: 17.5.3.1. Functions to scan USER_SOURCE, Advanced Oracle PL/SQL Programming with Packages
starts_multiline_comment function: 5.16.1. Analyzing PL/SQL string content, Advanced Oracle PL/SQL Programming with Packages
startup procedure
5.28.6. Tracing PL/SQL code execution, Advanced Oracle PL/SQL Programming with Packages
21.2.4.1. startup, Advanced Oracle PL/SQL Programming with Packages
22.1.6.5. Integrating PLVexc with PLVtrc , Advanced Oracle PL/SQL Programming with Packages
state versus stateless: 2.2.3. The HyperText Transfer Protocol (HTTP), Oracle Web Applications
statement_types parameter, ADD_POLICY procedure: 7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features
static SQL: 6.2.1. Types of Cursors, Oracle PL/SQL Programming
static cursors: 6.2.1. Types of Cursors, Oracle PL/SQL Programming
static resources
2.1. Resources, Oracle Web Applications
4.1. How OAS Returns Web Resources, Oracle Web Applications
statistics
(see also performance analysis)
7. Defining an Application Profile, Oracle Built-in Packages
objects: 10.3.3.1. The DBMS_DDL.ANALYZE_OBJECT procedure, Oracle Built-in Packages
partitioned objects: 10.1.2.3. The DBMS_UTILITY.ANALYZE_PART_OBJECT procedure (Oracle8 Only), Oracle Built-in Packages
schemas: 10.1.2.2. The DBMS_UTILITY.ANALYZE_SCHEMA procedure, Oracle Built-in Packages
tables: 13.4.1. Tracking Space in Tablespaces, Oracle Built-in Packages
status, module: 23.3. Module Validation and Dependency Management, Oracle PL/SQL Programming
statval function: 11.1.5.8. The memory procedure, Oracle Built-in Packages
std_delimiters constant: 5.21.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
stdout constant: 5.3.1. PL/Vision constants, Advanced Oracle PL/SQL Programming with Packages
stg_with_ln function: 16.4.3.3. Modularization inside put_line , Advanced Oracle PL/SQL Programming with Packages
stop procedure
5.10.6. Exception handlers, Advanced Oracle PL/SQL Programming with Packages
22.1.6.2. The high-level handlers, Advanced Oracle PL/SQL Programming with Packages
22.1.9. Halting in PLVexc, Advanced Oracle PL/SQL Programming with Packages
stop_and_drop procedure: 5.7.1. Improving AQ Ease of Use, Oracle Built-in Packages
stopping bailout process: 22.1.10.2. Starting and stopping the bailout, Advanced Oracle PL/SQL Programming with Packages
stopping programs: 22.1.9. Halting in PLVexc, Advanced Oracle PL/SQL Programming with Packages
store tables: 19.1. Types of Collections, Oracle PL/SQL Programming
stored code
23.7. Encrypting Stored Code, Oracle PL/SQL Programming
5.29. PLVvu: Code and Error Viewing , Advanced Oracle PL/SQL Programming with Packages
stored modules/packages: 1.4.3.11. Stored procedures, functions, and packages, Oracle PL/SQL Programming
stored objects: 23. Managing Code in the Database, Oracle PL/SQL Programming
execute authority on: 23.2.1. Execute Authority on Stored Objects, Oracle PL/SQL Programming
interdependency of: 23.3.1. Interdependencies of Stored Objects, Oracle PL/SQL Programming
managing with SQL*Plus: 23.5. Managing Stored Objects with SQL*Plus, Oracle PL/SQL Programming
synonyms for: 23.2.2. Creating Synonyms for Stored Objects, Oracle PL/SQL Programming
viewing with SQL: 23.6. Using SQL to Examine Stored Objects, Oracle PL/SQL Programming
stored procedures, PL/SQL Version 1.1: B. Calling Stored Procedures from PL/SQL Version 1.1, Oracle PL/SQL Programming
stored virtual REFs: 20.4.3. Storage of Virtual REFs, Oracle PL/SQL Programming
stored functions, PL/SQL
23.1.2. Executing Functions, Oracle PL/SQL Programming
17.1. Looking at the Problem, Oracle PL/SQL Programming
17.7. Realities: Calling PL/SQL Functions in SQL, Oracle PL/SQL Programming
calling packaged functions: 17.5. Calling Packaged Functions in SQL, Oracle PL/SQL Programming
examples of: 17.8. Examples of Embedded PL/SQL, Oracle PL/SQL Programming
name precedence and: 17.6. Column/Function Name Precedence, Oracle PL/SQL Programming
package variable modification: 17.4. Restrictions on PL/SQL Functions in SQL, Oracle PL/SQL Programming
read consistency and: 17.7.2. Read Consistency Model Complications, Oracle PL/SQL Programming
requirements/restrictions: 17.3. Requirements for Stored Functions in SQL, Oracle PL/SQL Programming
stored programs
describing parameters: 10.2. DBMS_DESCRIBE: Describing PL/SQL Program Headers, Oracle Built-in Packages
job execution and: 13.1.2.2. The what parameter, Oracle Built-in Packages
recompiling: 10.3.2. Compiling PL/SQL Objects, Oracle Built-in Packages
storyboards
8.1. Designing a Web Application, Oracle Web Applications
8.1.2. Create a Storyboard, Oracle Web Applications
streaming servers: 1.3.9.2. Multimedia data, Oracle Web Applications
string constant: 5.3.1. PL/Vision constants, Advanced Oracle PL/SQL Programming with Packages
string function: 5.4.2. Case-converting programs, Advanced Oracle PL/SQL Programming with Packages
string procedure
5.4.2. Case-converting programs, Advanced Oracle PL/SQL Programming with Packages
5.21.4. Parsing strings, Advanced Oracle PL/SQL Programming with Packages
10.1.3.5. string procedures, Advanced Oracle PL/SQL Programming with Packages
18.1.1.2. Converting a string, Advanced Oracle PL/SQL Programming with Packages
string_repostype TYPE: 12.2.1. String Source or Target, Advanced Oracle PL/SQL Programming with Packages
strings
(see also literals)
5.16. PLVlex: Lexical Analysis, Advanced Oracle PL/SQL Programming with Packages
2.3. Literals, Oracle PL/SQL Programming
SUBSTR function: A.2.5. Builtin Functions, Advanced Oracle PL/SQL Programming with Packages
adding characters to
11.1.11. The RPAD function, Oracle PL/SQL Programming
11.1.8. The LPAD function, Oracle PL/SQL Programming
case of
11.1.16. The UPPER function, Oracle PL/SQL Programming
11.1.4. The INITCAP function, Oracle PL/SQL Programming
11.1.7. The LOWER function, Oracle PL/SQL Programming
(see also capitalization)
code repository: 12.2.1. String Source or Target, Advanced Oracle PL/SQL Programming with Packages
comparing
4.2.3.2. The VARCHAR2 and VARCHAR datatypes, Oracle PL/SQL Programming
11.1.13. The SOUNDEX function, Oracle PL/SQL Programming
concatenating: 11.1.3. The CONCAT function, Oracle PL/SQL Programming
converting: 6.4.1. Converting Boolean to String, Advanced Oracle PL/SQL Programming with Packages
between character sets: 14.2.2. The CONVERT function, Oracle PL/SQL Programming
hexadecimal: 14.2.3. The HEXTORAW function, Oracle PL/SQL Programming
to row numbers: 10.5.1. Automatic Conversion of Row Number Expressions, Oracle PL/SQL Programming
to/from dates
14.1. Conversion Formats, Oracle PL/SQL Programming
14.2.6. The TO_CHAR function (date conversion), Oracle PL/SQL Programming
14.2.8. The TO_DATE function, Oracle PL/SQL Programming
to/from numbers
14.1.2. Number Format Models, Oracle PL/SQL Programming
14.2.7. The TO_CHAR function (number conversion), Oracle PL/SQL Programming
14.2.9. The TO_NUMBER function, Oracle PL/SQL Programming
17.8.7. Recursive Processing in a SQL Statement, Oracle PL/SQL Programming
counting atomics of: 10.1.3.3. numatomics function, Advanced Oracle PL/SQL Programming with Packages
datatypes for: 4.2.3. Character Datatypes, Oracle PL/SQL Programming
extracting characters from: 11.1.14. The SUBSTR function, Oracle PL/SQL Programming
finding substrings of: 11.1.5. The INSTR function, Oracle PL/SQL Programming
functions for: 11. Character Functions, Oracle PL/SQL Programming
justifying: 11.2.3. Filling Text to Fit a Line, Oracle PL/SQL Programming
length of: 11.1.6. The LENGTH function, Oracle PL/SQL Programming
output prefix: 7.3. The Output Prefix , Advanced Oracle PL/SQL Programming with Packages
parsing
5.21. PLVprs: String Parsing, Advanced Oracle PL/SQL Programming with Packages
10. PLVprs, PLVtkn, and PLVprsps: Parsing Strings, Advanced Oracle PL/SQL Programming with Packages
11.2.1. Parsing a Name, Oracle PL/SQL Programming
replacing characters in
11.1.10. The REPLACE function, Oracle PL/SQL Programming
11.1.15. The TRANSLATE function, Oracle PL/SQL Programming
searching for, in code: 23.6.4. Displaying and Searching Source Code, Oracle PL/SQL Programming
string functions: 16.2.3.3. Default values for string functions , Advanced Oracle PL/SQL Programming with Packages
stripping characters from
11.1.12. The RTRIM function, Oracle PL/SQL Programming
11.1.9. The LTRIM function, Oracle PL/SQL Programming
variable-length: 4.2.3.2. The VARCHAR2 and VARCHAR datatypes, Oracle PL/SQL Programming
verifying format of: 11.2.5. Verifying String Formats with TRANSLATE, Oracle PL/SQL Programming
word wrap: 11.2.2. Implementing Word Wrap for Long Text, Oracle PL/SQL Programming
wrapping: 10.1.4. Wrapping Strings into Paragraphs, Advanced Oracle PL/SQL Programming with Packages
stripped function: 5.6.3. Other functions and procedures, Advanced Oracle PL/SQL Programming with Packages
strong REF CURSOR type: (see cursor variables)
structure, code: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming
structure, data: (see data structures)
structured interface trace filtering: 26.4. Structured Interface Filtering, Oracle PL/SQL Programming
structured programming: 6.1. Structured Programming in PL/SQL , Oracle Web Applications
stub generation: B.1. Using Stubs to Talk to Server-Side PL/SQL, Oracle PL/SQL Programming
stubs
(see also documentation)
5.2.2.3. Supporting top-down design of modules, Oracle PL/SQL Programming
5.14.3. Help text stub generators, Advanced Oracle PL/SQL Programming with Packages
style, coding: 1.7.4. Standardize Your PL/SQL Development Environment, Oracle PL/SQL Programming
subblocks: (see nested blocks; nested modules)
subprograms, passing parameters to: 5.4. Using Cursor Attributes, Guide to Oracle8i Features
subqueries, correlated: 17.8.3. Replacing Correlated Subqueries, Oracle PL/SQL Programming
subscriber lists
5.1.2. Enqueue Features, Oracle Built-in Packages
5.1.5. A Glossary of Terms, Oracle Built-in Packages
privileges required to modify: 5.5.3. Managing Queue Subscribers, Oracle Built-in Packages
returning: 5.5.3.3. The DBMS_AQADM.QUEUE_SUBSCRIBERS procedure, Oracle Built-in Packages
table types for: 5.3.5. Recipient and Subscriber List Table Types, Oracle Built-in Packages
subscribers
adding: 5.5.3.1. The DBMS_AQADM.ADD_SUBSCRIBER procedure, Oracle Built-in Packages
removing: 5.5.3.2. The DBMS_AQADM.REMOVE_SUBSCRIBER procedure, Oracle Built-in Packages
substitution value for NULL: 5.3.4. Setting the NULL substitution value, Advanced Oracle PL/SQL Programming with Packages
substitution value, NULL: 6.1. Null Substitution Value, Advanced Oracle PL/SQL Programming with Packages
substrings
(see also strings)
counting occurrences of: 11.2.4. Counting Substring Occurrences in Strings, Oracle PL/SQL Programming
extracting from strings: 11.1.14. The SUBSTR function, Oracle PL/SQL Programming
finding: 11.1.5. The INSTR function, Oracle PL/SQL Programming
replacing
11.1.10. The REPLACE function, Oracle PL/SQL Programming
11.1.15. The TRANSLATE function, Oracle PL/SQL Programming
subtypes
1.4.4.4. Programmer-defined subtypes, Oracle PL/SQL Programming
4.6. Programmer-Defined Subtypes, Oracle PL/SQL Programming
suffixes
file: 2.4. Organizing Package Source Code, Advanced Oracle PL/SQL Programming with Packages
package element names: 2.3.3. Avoiding Superfluous Naming Elements, Advanced Oracle PL/SQL Programming with Packages
suppressing zeros/spaces: 14.3.1. FM: Suppressing Blanks and Zeros, Oracle PL/SQL Programming
surrogate SYS accounts: (see advanced replication, user accounts)
symbols
!= (not equals): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
% (percent sign): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
> (label delimeters): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
>= (greater than): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
<> (not equals): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
<= (less than): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
** (double asterisk): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
-- (comment indicator): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
/* and */ (comment block delimiters): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
; (semicolon): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
=> (associational operator for positional notation): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
\: (colon): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
_ (underscore): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
|| (concatenation) operator: 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
syn procedure: 5.8.3. Dumping the DDL, Advanced Oracle PL/SQL Programming with Packages
synchronization: 1.7.2. Synchronize Program and Data Structures, Oracle PL/SQL Programming
synchronization with columns: 4.5.1.1. Synchronization with database columns, Oracle PL/SQL Programming
synchronous mode, replication: 1.3.8.2. EnterpriseSync Lite, Oracle Web Applications
synonym wizard, WebDB: 3.1.2.1. Building database objects, Oracle Web Applications
synonyms for stored objects: 23.2.2. Creating Synonyms for Stored Objects, Oracle PL/SQL Programming
synonyms, PL/SQL: 2.5.3.2. Object privileges, Oracle Web Applications
synonyms, package: 4.3.6. Granting Access to PL/Vision, Advanced Oracle PL/SQL Programming with Packages
syntax, HTML: 5.1.2. Syntax, Oracle Web Applications
system
date: 12.1.7. The SYSDATE function, Oracle PL/SQL Programming
exceptions: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming
system errors, trapping: 6.2.1.3. Trapping system errors, Guide to Oracle8i Features
system level access control: 7.6.2. System-Level Access Control, Guide to Oracle8i Features
system memory, bulk collection: 5.3.1. Restricting Bulk Collection with ROWNUM , Guide to Oracle8i Features
system privileges: 2.5.3.1. System privileges, Oracle Web Applications
system-level events: 6.2. Database-Level Event Triggers, Guide to Oracle8i Features

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.