start page | rating of books | rating of authors | reviews | copyrights

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

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