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.