Book HomeBook HomeSearch this book

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


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
The Oracle Library Navigation

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference