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.