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

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