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: C
- calendar format (NLS), setting
: 11.1.2.3. The DBMS_SESSION.SET_NLS procedure
- CALL procedure (DBMS_DEFER)
- call stack, returning
: 10.1.2.10. The DBMS_UTILITY.FORMAT_CALL_STACK function
- CANCEL_STATISTICS procedure
- carriage returns
: (see newline markers)
- CAST_TO_RAW function : 9.2.3.5. The UTL_RAW.CAST_TO_RAW function
- CAST_TO_VARCHAR2 function : 9.2.3.6. The UTL_RAW.CAST_TO_VARCHAR2 function
- casting : (see conversions; specific CAST functions)
- caterr.sql : 15.3.6.3. The DBMS_REPCAT.PURGE_MASTER_LOG procedure
- catjobq.sql script : 13.1. Getting Started with DBMS_ JOB
- catlog.sql : 15.3.6.1. The DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN procedure
- catoctk.sql script : 10.4.1. Getting Started with DBMS_RANDOM
- catqueue.sql file : 5.6.1.1. The database table for queue data
- catrep.sql script
- CAST_TO_RAW function : 9.2.3.5. The UTL_RAW.CAST_TO_RAW function
- CHANGE procedure
- change_it_again procedure
: 5.7.8.2. Overriding with a recipient list
- CHAR_ARG procedure : 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure
- character large objects : (see CLOBs; NCLOBs)
- character sets
- CHAR_ARG procedure : 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure
- fixed-width
: (see CLOBs; NCLOBs)
- National Language Support, conversions for : 9.2.3.9. The UTL_RAW.CONVERT function
- variable-width
- National Language Support, conversions for : 9.2.3.9. The UTL_RAW.CONVERT function
- fixed-width
: (see CLOBs; NCLOBs)
- CHECK_PRIVS procedure
: 13.1.1. DBMS_JOB Programs
- client information
- client_info procedure
: 7.3.1. About the register_app Package
- client_request procedure : 3.1.7.5. The pipesvr package
- CLOB_ARG procedure : 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure
- CLOBs
- client_request procedure : 3.1.7.5. The pipesvr package
- CLOSE_CURSOR procedure
- CLOSE_DATABASE_LINK procedure
- close_item procedure
: 3.2.3.5. The auction package
- close_links procedure
- closepipe function
: 3.1.3.2. The DBMS_PIPE.REMOVE_PIPE function
- cluster segments, space utilization : 12.1. DBMS_SPACE: Obtaining Space Information
- coercions : 9.2.2.1. Conversion and coercion
- column groups : 16.2. Column Groups with DBMS_REPCAT
- cluster segments, space utilization : 12.1. DBMS_SPACE: Obtaining Space Information
- adding columns
: 16.2.3.1. The DBMS_REPCAT.ADD_GROUPED_COLUMN procedure
- comments, creating or replacing : 16.2.3.3. The DBMS_REPCAT.COMMENT_ON_COLUMN_GROUP procedure
- concepts : 16.2.1. About Column Groups
- creating with columns : 16.2.2.3. The DBMS_REPCAT.MAKE_COLUMN_GROUP procedure
- creating without columns : 16.2.2.1. The DBMS_REPCAT.DEFINE_COLUMN_GROUP procedure
- dropping column groups : 16.2.2.2. The DBMS_REPCAT.DROP_COLUMN_GROUP procedure
- dropping columns : 16.2.3.2. The DBMS_REPCAT.DROP_GROUPED_COLUMN procedure
- comments, creating or replacing : 16.2.3.3. The DBMS_REPCAT.COMMENT_ON_COLUMN_GROUP procedure
- adding columns
: 16.2.3.1. The DBMS_REPCAT.ADD_GROUPED_COLUMN procedure
- COLUMN_VALUE procedure
- COLUMN_VALUE_CHAR procedure
: 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure
- COLUMN_VALUE_LONG procedure
- COLUMN_VALUE_RAW procedure
: 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure
- COLUMN_VALUE_ROWID procedure : 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure
- columns
- COLUMN_VALUE_ROWID procedure : 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure
- datatype determination (example)
: 2.5.4.3. Constructing the SELECT
- datatype values for : 2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure
- defining
- datatype values for : 2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure
- describing
: 2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure
- pseudocolumns : 9.1.2. ROWID Concepts
- retrieving
- pseudocolumns : 9.1.2. ROWID Concepts
- retrieving descriptions of
: 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS
- retrieving number of in tables : 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS
- datatype determination (example)
: 2.5.4.3. Constructing the SELECT
- comma-delimited lists
- COMMA_TO_TABLE procedure
- COMMENT_ON_<conflicttype>_RESOLUTION procedure
- COMMENT_ON_COLUMN_GROUP procedure
- COMMENT_ON_DELETE_RESOLUTION procedure
: 16.5.1.3. The DBMS_REPCAT.COMMENT_ON_<conflicttype>_RESOLUTION procedure
- COMMENT_ON_PRIORITY_GROUP procedure
- COMMENT_ON_REPGROUP procedure
- COMMENT_ON_REPOBJECT procedure
- COMMENT_ON_REPSITES procedure
- COMMENT_ON_SITE_PRIORITY procedure
- COMMENT_ON_UNIQUE_RESOLUTION procedure
: 16.5.1.3. The DBMS_REPCAT.COMMENT_ON_<conflicttype>_RESOLUTION procedure
- COMMENT_ON_UPDATE_RESOLUTION procedure : 16.5.1.3. The DBMS_REPCAT.COMMENT_ON_<conflicttype>_RESOLUTION procedure
- COMMIT procedure
- COMMENT_ON_UPDATE_RESOLUTION procedure : 16.5.1.3. The DBMS_REPCAT.COMMENT_ON_<conflicttype>_RESOLUTION procedure
- COMMIT_COMMENT procedure
- COMMIT_FORCE procedure
- COMMIT_WORK procedure (DBMS_DEFER)
- commitment : 4.2.3. Committing Data
- alerts and
: 3.2.2.5. The DBMS_ALERT.SIGNAL procedure
- DDL statement processing and : 10.3.1. Getting Started with DBMS_DDL
- deferred transactions and
- DDL statement processing and : 10.3.1. Getting Started with DBMS_DDL
- job scheduling and
- locks
- allocating locks
: 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure
- named locks : 4.1.3.4. ALLOCATE_UNIQUE drawbacks
- persistence : 4.1.2.2. The DBMS_LOCK.REQUEST function
- named locks : 4.1.3.4. ALLOCATE_UNIQUE drawbacks
- allocating locks
: 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure
- alerts and
: 3.2.2.5. The DBMS_ALERT.SIGNAL procedure
- committed_TF function
: 4.1.4.1. The dblock package
- Companion Utilities Guide (diskette)
- COMPARE function (DBMS_LOB)
- COMPARE function (UTL_RAW)
: 9.2.3.7. The UTL_RAW.COMPARE function
- compatibility function : 10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure
- COMPILE_SCHEMA procedure
- compatibility function : 10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure
- compositing
: (see funneling in)
- compressed data : (see message buffers, compressed data in)
- CONCAT function : 9.2.3.8. The UTL_RAW.CONCAT function
- concatenation
- compressed data : (see message buffers, compressed data in)
- raw data
- SQL statement construction by : 2.3.4. Binding Values into Dynamic SQL
- binding versus concatenation
- concurrency, raw data and
: 9.2. UTL_RAW: Manipulating Raw Data
- conflict resolution
- (see also column groups; priority groups; site priority groups)
- 16. Conflict Resolution
- adding resolution types : 16.5.1.1. The DBMS_REPCAT.ADD_<conflicttype>_RESOLUTION
- auditing : 16.6. Monitoring Conflict Resolution with DBMS_REPCAT
- 16. Conflict Resolution
- purging data
: 16.6.1.3. The DBMS_REPCAT.PURGE_STATISTICS procedure
- starting data collection : 16.6.1.1. The DBMS_REPCAT.REGISTER_STATISTICS procedure
- stopping data collection : 16.6.1.2. The DBMS_REPCAT.CANCEL_STATISTICS procedure
- starting data collection : 16.6.1.1. The DBMS_REPCAT.REGISTER_STATISTICS procedure
- purging data
: 16.6.1.3. The DBMS_REPCAT.PURGE_STATISTICS procedure
- comments on resolution types, creating or replacing
: 16.5.1.3. The DBMS_REPCAT.COMMENT_ON_<conflicttype>_RESOLUTION procedure
- data dictionary views : 16.1.4. Data Dictionary Views
- dropping resolution types : 16.5.1.2. The DBMS_REPCAT.DROP_<conflicttype>_RESOLUTION procedure
- methods : 16.5.1. About Resolution Methods
- replication support and : 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure
- replication triggers and : 14.1.2.2. The DBMS_SNAPSHOT.SET_I_AM_A_REFRESH procedure
- data dictionary views : 16.1.4. Data Dictionary Views
- (see also column groups; priority groups; site priority groups)
- connections, PL/SQL and
: 2.4.7. Executing DDL in PL/SQL
- consistency
- dequeuing and
: 5.4.2.5. Dequeue navigation
- raw data and : 9.2. UTL_RAW: Manipulating Raw Data
- dequeuing and
: 5.4.2.5. Dequeue navigation
- consumers
- (see also multiple consumers; producers)
- 5.1.2. Enqueue Features
- 5.1.5. A Glossary of Terms
- delaying dequeuing : 5.3.6. Message Properties Record Type
- specifying : 5.3.8. Dequeue Options Record Type
- 5.1.2. Enqueue Features
- (see also multiple consumers; producers)
- conventions
: Conventions Used in This Book
- conversions
- CONVERT function
- COPIES function
: 9.2.3.10. The UTL_RAW.COPIES function
- COPY procedure (DBMS_DEFER_SYS)
- COPY procedure (DBMS_LOB)
- copyto procedure
- correlation identifiers : 5.3.6. Message Properties Record Type
- dequeuing and : 5.3.8. Dequeue Options Record Type
- wildcarding : 5.7.5.1. Wildcarded correlation identifiers
- covering encapsulation
: 1.3.5. Encapsulating Access to the Built-in Packages
- create_file procedure : 6.2.7.2. Creating a file
- CREATE_MASTER_REPGROUP procedure
- create_file procedure : 6.2.7.2. Creating a file
- CREATE_MASTER_REPOBJECT procedure
- CREATE_PIPE function
- create_priority_queue procedure
: 5.7.1. Improving AQ Ease of Use
- create_queue procedure : 5.7.1. Improving AQ Ease of Use
- CREATE_QUEUE procedure
- create_queue procedure : 5.7.1. Improving AQ Ease of Use
- CREATE_QUEUE_TABLE procedure
- CREATE_SNAPSHOT_REPGROUP procedure
- CREATE_SNAPSHOT_REPOBJECT procedure
- crefile.sp
: 6.2.7.2. Creating a file
- creind.sp : 2.1. Examples of Dynamic SQL
- currency format (NLS), setting : 11.1.2.3. The DBMS_SESSION.SET_NLS procedure
- current transaction, registering : 7.2.3. The DBMS_APPLICATION_INFO.SET_ACTION procedure
- current_choice function : 5.7.8.2. Overriding with a recipient list
- current_name function : 12.1.3.1. The segspace package
- current_row function : 7.3.9. Tracking Long-Running Processes
- current_schema function : 12.1.3.1. The segspace package
- current_type function : 12.1.3.1. The segspace package
- cursor variables, dynamic SQL and : 2.4.1. Some Restrictions
- cursors
- creind.sp : 2.1. Examples of Dynamic SQL
- checking status
- closing
- closing cached cursors
: 11.1.4.4. The DBMS_SESSION.SET_CLOSE_CACHED_OPEN_CURSORS procedure
- defining columns : 2.3.5. Defining Cursor Columns
- defining structure of (example) : 2.5.4.5. Defining the cursor structure
- executing associated SQL statement : 2.3.6.1. The DBMS_SQL.EXECUTE function
- LOBs and : 8.2.1.1. Internal and external LOBs
- obtaining structure of (example) : 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS
- opening
- defining columns : 2.3.5. Defining Cursor Columns
- pinning into shared pool
: 12.2.4.2. Pinning cursors into the shared pool
- reusing
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.