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

Index: S

sale package

(see also specific program names)

5.7.6. Using Time Delay and Expiration

Savant Corporation : About Q

SAVEPOINT procedure

4.2.1.1. DBMS_TRANSACTION programs

4.2.4.3. The DBMS_TRANSACTION.SAVEPOINT procedure

scalar values, binding : 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure

SCHEDULE_EXECUTION procedure

17.2.1.1. DBMS_DEFER_SYS programs

17.2.5.3. The DBMS_DEFER_SYS.SCHEDULE_EXECUTION procedure

schedule_pkg package

(see also specific program names)

5.7.7.2. Dequeuing messages when part of a group

SCHEDULE_PROPAGATION procedure

5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)

5.5.5.1. The DBMS_AQADM.SCHEDULE_PROPAGATION procedure

SCHEDULE_PURGE procedure

17.2.1.1. DBMS_DEFER_SYS programs

17.2.6.4. The DBMS_DEFER_SYS.SCHEDULE_PURGE procedure (Oracle8 only)

SCHEDULE_PUSH procedure

17.2.1.1. DBMS_DEFER_SYS programs

17.2.6.5. The DBMS_DEFER_SYS.SCHEDULE_PUSH procedure (Oracle8 only)

scheduled links : 17.2.6. Scheduling Propagation (Oracle8 only)

scheduling : (see deferred transactions; propagating messages)

schemas

analyzing : 10.1.2.2. The DBMS_UTILITY.ANALYZE_SCHEMA procedure

compiling : 10.1.2.5. The DBMS_UTILITY.COMPILE_SCHEMA procedure

names for, returning : 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure

scope of variables in dynamic SQL : 2.4.8. Executing Dynamic PL/SQL

security

DBMS_PIPE and : 3.1. DBMS_PIPE: Communicating Between Sessions

distinguishing users : 7.2.4.2. Example

UTL_FILE and : 6.2.1.3. File security

SEED procedure

10.4.1. Getting Started with DBMS_RANDOM

10.4.2.2. The DBMS_RANDOM.SEED procedure (Oracle8 only)

segspace package

(see also specific program names)

1.3.5.1. Examples of encapsulation packages

12.1.3.1. The segspace package

segspace.sql : 12.1.3.1. The segspace package

SELECT statements

constructing (example) : 2.5.4.3. Constructing the SELECT

defining columns for : 2.3.1. Processing Flow of Dynamic SQL

dynamic execution of : 2. Executing Dynamic SQL and PL/SQL

LONG values versus : 2.3.8.2. The DBMS_SQL.COLUMN_VALUE_LONG procedure

SELECT_OBJECT procedure : 9.2.5.3. The UTL_REF.SELECT_OBJECT procedure

SEND_AND_COMPARE_OLD_VALUES procedure

15.3.1.1. DBMS_REPCAT programs

15.3.8.3. The DBMS_REPCAT.SEND_AND_COMPARE_OLD_VALUES procedure (Oracle8 only)

SEND_MESSAGE function

3.1.1.1. DBMS_PIPE programs

3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function

creating pipes : 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function

sepchar function : 6.2.6.3. Combining locations and filenames

serializing access, DBMS_LOCK and : 4.1. DBMS_LOCK: Creating and Managing Resource Locks

server files : (see files)

server procedure : 3.1.7.5. The pipesvr package

server_status procedure : 3.1.7.5. The pipesvr package

server_stop procedure : 3.1.7.5. The pipesvr package

servers

parallel server mode, testing for : 10.1.2.15. The DBMS_UTILITY.IS_PARALLEL_SERVER function

resource management : 12. Managing Server Resources

sess1.sql : 11.1.4.3. The DBMS_SESSION.RESET_PACKAGE procedure

sess2.sql : 11.1.5.8. The memory procedure

session labels

setting format : 11.1.2.2. DBMS_SESSION.SET_MLS_LABEL_FORMAT procedure

setting value : 11.1.2.1. The DBMS_SESSION.SET_LABEL procedure

session monitoring : (see performance analysis)

session names, returning unique name : 3.1.3.5. The DBMS_PIPE.UNIQUE_SESSION_NAME function

sessions

action names, returning : 7.2.2. The DBMS_APPLICATION_INFO.READ_MODULE procedure

identifiers for : 11.1.3.2. The DBMS_SESSION.UNIQUE_SESSION_ID function

enhancement

11.1.5.2. The unique_id function

11.1.5.4. The sid function

modifying settings : 11.1.2. Modifying Session Settings

obtaining information about : 11.1.3. Obtaining Session Information

enhancement : 11.1.5.3. The load_my_session_rec procedure

program names, returning : 7.2.2. The DBMS_APPLICATION_INFO.READ_MODULE procedure

resource management : 11.1.4. Managing Session Resources

session information : 11.1. DBMS_SESSION: Managing Session Information

settings, job execution and : 13.1.2.2. The what parameter

suspending with SLEEP : 4.1.2.5. The DBMS_LOCK.SLEEP procedure

tracing

another session : 11.2.2.3. The DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure

same session : 11.1.4.5. The DBMS_SESSION.SET_SQL_TRACE procedure

SET clause, array updating and : 2.5.6.3. Using array processing to update

SET SERVEROUTPUT (SQL*)

6.1.2.2. The DBMS_OUTPUT.DISABLE procedure

6.1.5. Tips on Using DBMS_OUTPUT

SET_ACTION procedure

7.1.1. DBMS_APPLICATION_INFO Programs

7.2.3. The DBMS_APPLICATION_INFO.SET_ACTION procedure

SET_CLIENT_INFO procedure

7.1.1. DBMS_APPLICATION_INFO Programs

7.2.4. The DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure

SET_CLOSE_CACHED_OPEN_CURSORS procedure

11.1.1.1. DBMS_SESSION programs

11.1.4.4. The DBMS_SESSION.SET_CLOSE_CACHED_OPEN_CURSORS procedure

SET_COLUMNS procedure

15.3.1.1. DBMS_REPCAT programs

15.3.3.2. The DBMS_REPCAT.SET_COLUMNS procedure

set_current_row procedure : 7.3.9. Tracking Long-Running Processes

SET_DEFAULTS procedure

3.2.1.1. DBMS_ALERT programs

3.2.2.4. The DBMS_ALERT.SET_DEFAULTS procedure

SET_DISABLED procedure

17.2.1.1. DBMS_DEFER_SYS programs

17.2.4.5. The DBMS_DEFER_SYS.SET_DISABLED procedure

SET_EV procedure

11.2.1. Getting Started with DBMS_SYSTEM

11.2.2.2. The DBMS_SYSTEM.SET_EV procedure

SET_I_AM_A_REFRESH procedure

14.1.1. Getting Started with DBMS_SNAPSHOT

14.1.2.2. The DBMS_SNAPSHOT.SET_I_AM_A_REFRESH procedure

SET_LABEL procedure

11.1.1.1. DBMS_SESSION programs

11.1.2.1. The DBMS_SESSION.SET_LABEL procedure

SET_MLS_LABEL_FORMAT procedure

11.1.1.1. DBMS_SESSION programs

11.1.2.2. DBMS_SESSION.SET_MLS_LABEL_FORMAT procedure

SET_MODULE procedure

7.1.1. DBMS_APPLICATION_INFO Programs

7.2.5. The DBMS_APPLICATION_INFO.SET_MODULE procedure

SET_NLS procedure

11.1.1.1. DBMS_SESSION programs

11.1.2.3. The DBMS_SESSION.SET_NLS procedure

SET_ROLE procedure

11.1.1.1. DBMS_SESSION programs

11.1.2.4. The DBMS_SESSION.SET_ROLE procedure

set_row procedure : 7.3.9. Tracking Long-Running Processes

set_segment procedure : 12.1.3.1. The segspace package

SET_SESSION_LONGOPS procedure

7.1.1. DBMS_APPLICATION_INFO Programs

7.2.6. The DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure

7.3.9. Tracking Long-Running Processes

encapsulating : 7.3.9. Tracking Long-Running Processes

set_sql_trace procedure

11.1.5.1. Adding value to DBMS_SESSION

11.1.5.6. The set_sql_trace procedure

SET_SQL_TRACE procedure

11.1.1.1. DBMS_SESSION programs

11.1.4.5. The DBMS_SESSION.SET_SQL_TRACE procedure

SET_SQL_TRACE_IN_SESSION procedure

11.2.1. Getting Started with DBMS_SYSTEM

11.2.2.3. The DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure

set_stats procedure : 7.3.3. The set_stats Procedure

set_trace procedure : 11.2.3. DBMS_SYSTEM Examples

setpath procedure : 6.2.6.4. Adding support for paths

setsepchar procedure : 6.2.6.3. Combining locations and filenames

shared pool

(see also pipes)

3.1. DBMS_PIPE: Communicating Between Sessions

12.2. DBMS_SHARED_POOL: Pinning Objects

memory freed and : 11.1.4.2. The DBMS_SESSION.FREE_UNUSED_USER_MEMORY procedure

pinning

cursors : 12.2.4.2. Pinning cursors into the shared pool

objects : 12.2.2.1. The DBMS_SHARED_POOL.KEEP procedure

packages at startup (example) : 12.2.4.1. Pinning packages automatically

size information

12.2.3.1. The DBMS_SHARED_POOL.SIZES procedure

12.2.4.3. The DBA_KEEPSIZES view

size threshold : 12.2.3.2. The DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD procedure

unpinning objects : 12.2.2.2. The DBMS_SHARED_POOL.UNKEEP procedure

show procedure : 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS

show_by_group procedure : 5.7.7.2. Dequeuing messages when part of a group

show_changers_to procedure : 5.7.8.1. Using the subscriber list

show_expired_sales procedure : 5.7.6. Using Time Delay and Expiration

show_name_components procedure : 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure

showargs procedure : 10.2.3.1. Features of the psdesc package

showcomp.sp : 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure

showemps.sp : 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure

showmsgs procedure : 5.7.1. Improving AQ Ease of Use

showsubs.sp : 5.5.3.3. The DBMS_AQADM.QUEUE_SUBSCRIBERS procedure

showsubs.sql : 5.5.3.3. The DBMS_AQADM.QUEUE_SUBSCRIBERS procedure

sid function : 11.1.5.4. The sid function

SIGNAL procedure

3.2.1.1. DBMS_ALERT programs

3.2.2.5. The DBMS_ALERT.SIGNAL procedure

single-character substitution (_) : 5.7.5.1. Wildcarded correlation identifiers

site priority groups : 16.4. Site Priority Groups with DBMS_REPCAT

adding sites : 16.4.3.1. The DBMS_REPCAT.ADD_SITE_PRIORITY_SITE procedure

altering site priority : 16.4.3.3. The DBMS_REPCAT.ALTER_SITE_PRIORITY procedure

altering sites by name : 16.4.3.4. The DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE

comments, creating or changing : 16.4.2.3. The DBMS_REPCAT.COMMENT_ON_SITE_PRIORITY procedure

concepts : 16.4.1. About Site Priority Groups

creating : 16.4.2.1. The DBMS_REPCAT.DEFINE_SITE_PRIORITY procedure

dropping site priorities by priority level : 16.4.3.2. The DBMS_REPCAT.DROP_SITE_PRIORITY_SITE procedure

dropping site priority groups : 16.4.2.2. The DBMS_REPCAT.DROP_SITE_PRIORITY procedure

dropping sites by name : 16.4.3.2. The DBMS_REPCAT.DROP_SITE_PRIORITY_SITE procedure

SIZES procedure

12.2.1. Getting Started with DBMS_SHARED_POOL

12.2.3.1. The DBMS_SHARED_POOL.SIZES procedure

SLEEP procedure

4.1.1.1. DBMS_LOCK programs

4.1.2.5. The DBMS_LOCK.SLEEP procedure

slicing and dicing byte strings : 9.2.2.2. Slicing and dicing

smart_job procedure : 13.4.3. Self-Modifying and Self-Aware Jobs

snapshot groups

adding snapshots : 14.2.3.1. The DBMS_REFRESH.ADD procedure

changing properties : 14.2.4. Altering Properties of a Snapshot Group

creating : 14.2.2.1. The DBMS_REFRESH.MAKE procedure

destroying : 14.2.2.2. The DBMS_REFRESH.DESTROY procedure

dropping all snapshots and snapshot groups : 14.2.2.1. The DBMS_REFRESH.MAKE procedure

refreshing : 14.2.5. Manually Refreshing Snapshot Groups

subtracting snapshots : 14.2.3.2. The DBMS_REFRESH.SUBTRACT procedure

snapshot logs

fast refresh and : 14.1.3.1. The DBMS_SNAPSHOT.REFRESH procedure

master site switching and : 14.4.6.1. The DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER procedure

purging : 14.1.4. Purging the Snapshot Log

snapshot replication groups

adding objects to : 14.4.3.1. The DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT procedure

creating : 14.4.2.1. The DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP procedure

dropping : 14.4.2.3. The DBMS_REPCAT.DROP_SNAPSHOT_REPGROUP procedure

dropping objects from : 14.4.3.2. The DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT procedure

propagation mode alteration : 14.4.4. Altering a Snapshot Replication Group's Propagation Mode

refreshing : 14.4.5. Manually Refreshing a Snapshot Replication Group

switching master site : 14.4.6.1. The DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER procedure

snapshots

beginning import : 14.3.2.1. The DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD procedure

dropping all snapshots and snapshot groups : 14.2.2.1. The DBMS_REFRESH.MAKE procedure

droppping replication groups and : 15.3.2.2. The DBMS_REPCAT.DROP_MASTER_REPGROUP procedure

ending import : 14.3.2.2. The DBMS_OFFLINE_SNAPSHOT.END_LOAD procedure

export/import (loading) : 14.3.2. DBMS_OFFLINE_SNAPSHOT Interface

instantiation

14.3. DBMS_OFFLINE_SNAPSHOT: Performing Offline Snapshot Instantiation

14.4.2.2. The offline snapshot instantiation procedure

refresh state : 14.1.2.1. The DBMS_SNAPSHOT.I_AM_A_REFRESH function

refreshing : 14.1.3. Refreshing Snapshots

rollback and : 14.1.3.1. The DBMS_SNAPSHOT.REFRESH procedure

registering : 14.1.6. Registering Snapshots

unregistering : 14.1.6.2. The DBMS_SNAPSHOT.UNREGISTER_SNAPSHOT procedures (Oracle8 only)

SNP background processes : 13.2.1.1. JOB_QUEUE_PROCESSES

sort order (NLS), setting : 11.1.2.3. The DBMS_SESSION.SET_NLS procedure

space

deallocating unused space : 12.1.2.2. The DBMS_SPACE.UNUSED_SPACE procedure

freelist blocks available : 12.1.2.1. The DBMS_SPACE.FREE_BLOCKS procedure

unused space information : 12.1.2.2. The DBMS_SPACE.UNUSED_SPACE procedure

utilization information : 12.1. DBMS_SPACE: Obtaining Space Information

space_logger procedure : 13.4.1. Tracking Space in Tablespaces

spcex1.sql : 12.1.2.2. The DBMS_SPACE.UNUSED_SPACE procedure

spcex2.sql : 12.1.3.1. The segspace package

special characters (NLS), setting : 11.1.2.3. The DBMS_SESSION.SET_NLS procedure

sptimer.spb : 10.1.2.14. The DBMS_UTILITY.GET_TIME function

sptimer.sps : 10.1.2.14. The DBMS_UTILITY.GET_TIME function

SQL function codes : 2.3.10.4. The DBMS_SQL.LAST_SQL_FUNCTION_CODE function

SQL statements

(see also DDL statements; DML statements; long SQL statements)

2.2.6. DBMS_SQL Nonprogram Elements

combining into one program : 2.4.3. Combining Operations

constructing : 2.3.4. Binding Values into Dynamic SQL

binding versus concatenation

2.3.4. Binding Values into Dynamic SQL

2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure

executing : 2.3.1. Processing Flow of Dynamic SQL

function codes : 2.3.10.4. The DBMS_SQL.LAST_SQL_FUNCTION_CODE function

functions, invoking : 1.3.7.1. Calling a packaged function in SQL

parsing

2.3.1. Processing Flow of Dynamic SQL

2.3.3. Parsing the SQL Statement

deferred : 2.3.3.1. The DBMS_SQL.PARSE procedure

error position in : 2.3.10.1. The DBMS_SQL.LAST_ERROR_POSITION function

language version : 2.2.6. DBMS_SQL Nonprogram Elements

performance improvement : 2.4.5. Improving the Performance of Dynamic SQL

procedures, calling : 1.3.7.2. Using a packaged procedure from within SQL

SQL tracing, reasons for using : 7.3.8. Session Monitoring and Three-Tier Architectures

sqlarea.sql : 7.3.7. Monitoring Application SQL Resource Consumption

SQLCODE

exception types and : 1.3.4. Exception Handling and Built-in Packages

UTL_FILE and : 6.2.6.1. Handling file I/O errors

SQLERRM

exception types and : 1.3.4. Exception Handling and Built-in Packages

LAST_ERROR_POSITION and : 2.3.10.1. The DBMS_SQL.LAST_ERROR_POSITION function

UTL_FILE and : 6.2.6.1. Handling file I/O errors

square brackets ([ ]) : 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure

stacks

(see also call stack; error stack)

10.1.2.11. The DBMS_UTILITY.FORMAT_ERROR_STACK function

AQ example : 5.7.3. Building a Stack with AQ Using Sequence Deviation

standalone procedures, deferred RPCs and : 17.3.2.2. The DBMS_DEFER.CALL procedure

STANDARD package : 1.4.1. The STANDARD Package

standard system exceptions

1.3.4. Exception Handling and Built-in Packages

1.3.4.3. Standard system exception

standard.sql file : 1.4.1. The STANDARD Package

START_QUEUE procedure

5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)

5.5.2.2. The DBMS_AQADM.START_QUEUE procedure

START_TIME_MANAGER procedure

5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)

5.5.7.1. The DBMS_AQADM.START_TIME_MANAGER procedure

statistics

(see also performance analysis)

7. Defining an Application Profile

objects : 10.3.3.1. The DBMS_DDL.ANALYZE_OBJECT procedure

partitioned objects : 10.1.2.3. The DBMS_UTILITY.ANALYZE_PART_OBJECT procedure (Oracle8 Only)

schemas : 10.1.2.2. The DBMS_UTILITY.ANALYZE_SCHEMA procedure

tables : 13.4.1. Tracking Space in Tablespaces

statval function : 11.1.5.8. The memory procedure

STEP_ID function

4.2.1.1. DBMS_TRANSACTION programs

4.2.7.2. The DBMS_TRANSACTION.STEP_ID function

stop_and_drop procedure : 5.7.1. Improving AQ Ease of Use

STOP_QUEUE procedure

5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)

5.5.4.1. The DBMS_AQADM.STOP_QUEUE procedure

STOP_TIME_MANAGER procedure

5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)

5.5.7.2. The DBMS_AQADM.STOP_TIME_MANAGER procedure

stored programs

describing parameters : 10.2. DBMS_DESCRIBE: Describing PL/SQL Program Headers

job execution and : 13.1.2.2. The what parameter

recompiling : 10.3.2. Compiling PL/SQL Objects

strong typing : (see data typing)

Study Conduction, Institute for : 1.3.5. Encapsulating Access to the Built-in Packages

SUBMIT procedure

13.1.1. DBMS_JOB Programs

13.2.5.1. The DBMS_JOB.SUBMIT procedure

subscriber lists

5.1.2. Enqueue Features

5.1.5. A Glossary of Terms

privileges required to modify : 5.5.3. Managing Queue Subscribers

returning : 5.5.3.3. The DBMS_AQADM.QUEUE_SUBSCRIBERS procedure

table types for : 5.3.5. Recipient and Subscriber List Table Types

subscribers

adding : 5.5.3.1. The DBMS_AQADM.ADD_SUBSCRIBER procedure

removing : 5.5.3.2. The DBMS_AQADM.REMOVE_SUBSCRIBER procedure

SUBSTR function

8.1.1. DBMS_LOB Programs

8.3.2.4. The DBMS_LOB.SUBSTR function

9.2.3.14. The UTL_RAW.SUBSTR function

READ versus

8.3.2.3. The DBMS_LOB.READ procedure

8.3.2.4. The DBMS_LOB.SUBSTR function

SUBTRACT procedure

14.2.1. Getting Started with DBMS_REFRESH

14.2.3.2. The DBMS_REFRESH.SUBTRACT procedure

surrogate SYS accounts : (see advanced replication, user accounts)

SUSPEND_MASTER_ACTIVITY procedure

15.3.1.1. DBMS_REPCAT programs

15.3.7.1. The DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY procedure

SWITCH_SNAPSHOT_MASTER procedure

14.4.1.1. DBMS_REPCAT programs

14.4.6.1. The DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER procedure

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