Book HomeBook HomeSearch this book

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
The Oracle Library Navigation

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference