start page | rating of books | rating of authors | reviews | copyrights

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

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

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