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)
  17.3.1.1. DBMS_DEFER programs
  17.3.2.2. The DBMS_DEFER.CALL procedure
call stack, returning : 10.1.2.10. The DBMS_UTILITY.FORMAT_CALL_STACK function
CANCEL_STATISTICS procedure
  16.1.1. DBMS_REPCAT Programs
  16.6.1.2. The DBMS_REPCAT.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
  16.1. Getting Started with DBMS_REPCAT
  17.2.1. Getting Started with DBMS_DEFER_SYS
  17.3.1. Getting Started with DBMS_DEFER
  17.4.1. Getting Started with DBMS_DEFER_QUERY
CHANGE procedure
  13.1.1. DBMS_JOB Programs
  13.2.6.1. The DBMS_JOB.CHANGE procedure
  14.2.1. Getting Started with DBMS_REFRESH
  14.2.4. Altering Properties of a Snapshot Group
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
  fixed-width : (see CLOBs; NCLOBs)
  National Language Support, conversions for : 9.2.3.9. The UTL_RAW.CONVERT function
  variable-width
    8.2.1.4. The CLOB datatype
    8.2.1.5. The NCLOB datatype
CHECK_PRIVS procedure : 13.1.1. DBMS_JOB Programs
client information
  registering : 7.2.4. The DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure
  returning : 7.2.1. The DBMS_APPLICATION_INFO.READ_CLIENT_INFO procedure
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
  8.2.1. LOB Datatypes
  8.2.1.4. The CLOB datatype
CLOSE_CURSOR procedure
  2.2.3. DBMS_SQL Programs
  2.3.9.1. The DBMS_SQL.CLOSE_CURSOR procedure
CLOSE_DATABASE_LINK procedure
  11.1.1.1. DBMS_SESSION programs
  11.1.4.1. The DBMS_SESSION.CLOSE_DATABASE_LINK procedure
close_item procedure : 3.2.3.5. The auction package
close_links procedure
  11.1.5.1. Adding value to DBMS_SESSION
  11.1.5.5. The 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
  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
COLUMN_VALUE procedure
  2.2.3. DBMS_SQL Programs
  2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure
  Method 4 dynamic SQL and : 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL
COLUMN_VALUE_CHAR procedure : 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure
COLUMN_VALUE_LONG procedure
  2.2.3. DBMS_SQL Programs
  2.3.8.2. The DBMS_SQL.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
  datatype determination (example) : 2.5.4.3. Constructing the SELECT
  datatype values for : 2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure
  defining
    2.3.1. Processing Flow of Dynamic SQL
    2.3.5. Defining Cursor Columns
  describing : 2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure
  pseudocolumns : 9.1.2. ROWID Concepts
  retrieving
    2.3.1. Processing Flow of Dynamic SQL
    2.3.8. Retrieving Values
  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
comma-delimited lists
  creating : 10.1.2.20. The DBMS_UTILITY.TABLE_TO_COMMA procedure
  parsing : 10.1.2.4. The DBMS_UTILITY.COMMA_TO_TABLE procedure
COMMA_TO_TABLE procedure
  10.1.1. Getting Started with DBMS_UTILITY
  10.1.2.4. The DBMS_UTILITY.COMMA_TO_TABLE procedure
COMMENT_ON_<conflicttype>_RESOLUTION procedure
  16.1.1. DBMS_REPCAT Programs
  16.5.1.3. The DBMS_REPCAT.COMMENT_ON_<conflicttype>_RESOLUTION procedure
COMMENT_ON_COLUMN_GROUP procedure
  16.1.1. DBMS_REPCAT Programs
  16.2.3.3. The DBMS_REPCAT.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
  16.1.1. DBMS_REPCAT Programs
  16.3.2.3. The DBMS_REPCAT.COMMENT_ON_PRIORITY_GROUP procedure
COMMENT_ON_REPGROUP procedure
  15.3.1.1. DBMS_REPCAT programs
  15.3.2.3. The DBMS_REPCAT.COMMENT_ON_REPGROUP procedure
COMMENT_ON_REPOBJECT procedure
  15.3.1.1. DBMS_REPCAT programs
  15.3.3.6. The DBMS_REPCAT.COMMENT_ON_REPOBJECT procedure
COMMENT_ON_REPSITES procedure
  15.3.1.1. DBMS_REPCAT programs
  15.3.5.3. The DBMS_REPCAT.COMMENT_ON_REPSITES procedure
COMMENT_ON_SITE_PRIORITY procedure
  16.1.1. DBMS_REPCAT Programs
  16.4.2.3. The DBMS_REPCAT.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
  4.2.1.1. DBMS_TRANSACTION programs
  4.2.3.1. The DBMS_TRANSACTION.COMMIT procedure
COMMIT_COMMENT procedure
  4.2.1.1. DBMS_TRANSACTION programs
  4.2.3.2. The DBMS_TRANSACTION.COMMIT_COMMENT procedure
COMMIT_FORCE procedure
  4.2.1.1. DBMS_TRANSACTION programs
  4.2.3.3. The DBMS_TRANSACTION.COMMIT_FORCE procedure
COMMIT_WORK procedure (DBMS_DEFER)
  17.3.1.1. DBMS_DEFER programs
  17.3.2.3. The DBMS_DEFER.COMMIT_WORK procedure
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
    17.2.4.5. The DBMS_DEFER_SYS.SET_DISABLED procedure
    17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure
    17.3.2.3. The DBMS_DEFER.COMMIT_WORK procedure
  job scheduling and
    13.2.5.1. The DBMS_JOB.SUBMIT procedure
    13.2.7.3. The DBMS_JOB.RUN procedure
  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
committed_TF function : 4.1.4.1. The dblock package
Companion Utilities Guide (diskette)
  A. What's on the Companion Disk?
  About the Disk
COMPARE function (DBMS_LOB)
  8.1.1. DBMS_LOB Programs
  8.3.2.1. The DBMS_LOB.COMPARE function
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
  10.1.1. Getting Started with DBMS_UTILITY
  10.1.2.5. The DBMS_UTILITY.COMPILE_SCHEMA 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
  raw data
    9.2.3.10. The UTL_RAW.COPIES function
    9.2.3.8. The UTL_RAW.CONCAT function
  SQL statement construction by : 2.3.4. Binding Values into Dynamic SQL
    binding versus concatenation
      2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure 2.3.4. Binding Values into Dynamic SQL
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
    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
  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
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
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
conventions : Conventions Used in This Book
conversions
  GET_LINE and : 6.2.3.1. The UTL_FILE.GET_LINE procedure
  raw data and
    9.2.2.1. Conversion and coercion
    9.2.3.5. The UTL_RAW.CAST_TO_RAW function
    9.2.3.9. The UTL_RAW.CONVERT function
CONVERT function
  4.1.1.1. DBMS_LOCK programs
  4.1.2.3. The DBMS_LOCK.CONVERT function
  9.2.3.9. The UTL_RAW.CONVERT function
COPIES function : 9.2.3.10. The UTL_RAW.COPIES function
COPY procedure (DBMS_DEFER_SYS)
  17.2.1.1. DBMS_DEFER_SYS programs
  17.2.3. Copying Deferred Transactions to New Destinations
COPY procedure (DBMS_LOB)
  8.1.1. DBMS_LOB Programs
  8.3.3.2. The DBMS_LOB.COPY procedure
copyto procedure
  2.5.5. Indirect Referencing in PL/SQL
  2.5.5.3. Copying a value to a packaged variable
correlation identifiers : 5.3.6. Message Properties Record Type
  dequeuing and : 5.3.8. Dequeue Options Record Type
    example : 5.7.5. Searching by Correlation Identifier
  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
  15.3.2.1. The DBMS_REPCAT.CREATE_MASTER_REPGROUP procedure
  15.3.1.1. DBMS_REPCAT programs
CREATE_MASTER_REPOBJECT procedure
  15.3.1.1. DBMS_REPCAT programs
  15.3.3.1. The DBMS_REPCAT.CREATE_MASTER_REPOBJECT procedure
CREATE_PIPE function
  3.1.1.1. DBMS_PIPE programs
  3.1.3.1. The DBMS_PIPE.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
  5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)
  5.5.2.1. The DBMS_AQADM.CREATE_QUEUE procedure
CREATE_QUEUE_TABLE procedure
  5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)
  5.5.1.2. The DBMS_AQADM.CREATE_QUEUE_TABLE procedure
  LOB storage and : 5.3.3. Queue Type Names
CREATE_SNAPSHOT_REPGROUP procedure
  14.4.1.1. DBMS_REPCAT programs
  14.4.2.1. The DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP procedure
CREATE_SNAPSHOT_REPOBJECT procedure
  14.4.3.1. The DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT procedure
  14.4.1.1. DBMS_REPCAT programs
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
  checking status
    2.3.10. Checking Cursor Status
    2.3.2.2. The DBMS_SQL.IS_OPEN function
  closing
    2.3.1. Processing Flow of Dynamic SQL
    2.3.9. Closing the Cursor
    2.3.9.1. The DBMS_SQL.CLOSE_CURSOR procedure
    2.4.4. Minimizing Memory for Cursors
  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
    2.3.1. Processing Flow of Dynamic SQL
    2.3.2. Opening the Cursor
    2.3.2.1. The DBMS_SQL.OPEN_CURSOR function
  pinning into shared pool : 12.2.4.2. Pinning cursors into the shared pool
  reusing
    2.3.2.1. The DBMS_SQL.OPEN_CURSOR function
    2.3.4. Binding Values into Dynamic SQL
    2.4.4. Minimizing Memory for Cursors

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.