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

CD Home

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 | Y | Z

Index: C

C programs, writing: 1.3.8.1. Oracle Lite, Oracle Web Applications
CA (certification authority): 2.5.5. Additional Security Precautions, Oracle Web Applications
CALENDARPRINT procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
CALL constant, DBMS_LOB package: 7.5.2.1. CREATETEMPORARY: Creating a temporary LOB, Guide to Oracle8i Features
CALL procedure (DBMS_DEFER)
17.3.1.1. DBMS_DEFER programs, Oracle Built-in Packages
17.3.2.2. The DBMS_DEFER.CALL procedure, Oracle Built-in Packages
CANCEL_STATISTICS procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.6.1.2. The DBMS_REPCAT.CANCEL_STATISTICS procedure, Oracle Built-in Packages
CASE statements
6.1. Structured Programming in PL/SQL , Oracle Web Applications
6.2.3. Conditionals, Oracle Web Applications
CAST Workbench: 6.4. PL/SQL Tools, Oracle Web Applications
CAST procedure
10.3.2. The CAST Function, Guide to Oracle8i Features
object views and: 20.1. Example: Using Object Views, Oracle PL/SQL Programming
CAST pseudo-function: 19.5.2. The CAST Pseudo-function, Oracle PL/SQL Programming
CAST...MULTISET operation
1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
6.1. Triggers on Nested Table View Columns, Guide to Oracle8i Features
CAST_TO_RAW function: 9.2.3.5. The UTL_RAW.CAST_TO_RAW function, Oracle Built-in Packages
CAST_TO_VARCHAR2 function: 9.2.3.6. The UTL_RAW.CAST_TO_VARCHAR2 function, Oracle Built-in Packages
CDE (Cooperative Development Environment): 1.2. The Concept of Programming in Oracle Applications, Oracle PL/SQL Programming
CEIL (ceiling) function: 13.1.6. The CEIL function, Oracle PL/SQL Programming
CELLSPRINT procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
CGI (common gateway interface): 4.1. How OAS Returns Web Resources, Oracle Web Applications
CHANGE procedure
13.1.1. DBMS_JOB Programs, Oracle Built-in Packages
13.2.6.1. The DBMS_JOB.CHANGE procedure, Oracle Built-in Packages
14.2.1. Getting Started with DBMS_REFRESH, Oracle Built-in Packages
14.2.4. Altering Properties of a Snapshot Group, Oracle Built-in Packages
C.5.2. The CHANGE procedure, Oracle PL/SQL Programming
OWA_PATTERN package: 7.2.2.3. Procedures and functions, Oracle Web Applications
CHAR datatype
2.3. Literals, Oracle PL/SQL Programming
4.2.3.1. The CHAR datatype, Oracle PL/SQL Programming
converting to VARCHAR2: 4.2.3.2. The VARCHAR2 and VARCHAR datatypes, Oracle PL/SQL Programming
converting to/from ROWID
14.2.1. The CHARTOROWID function, Oracle PL/SQL Programming
14.2.5. The ROWIDTOCHAR function, Oracle PL/SQL Programming
with LENGTH function: 11.1.6. The LENGTH function, Oracle PL/SQL Programming
CHARSETFORM property: 21.4.3.4. CHARSETID and CHARSETFORM properties, Oracle PL/SQL Programming
CHARSETID property: 21.4.3.4. CHARSETID and CHARSETFORM properties, Oracle PL/SQL Programming
CHARTOROWID function: 14.2.1. The CHARTOROWID function, Oracle PL/SQL Programming
CHAR_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages
CHECKSUM procedure, OWA_OPT_LOCK package: 7.3.2.2. Procedures and functions, Oracle Web Applications
CHECK_PRIVS procedure: 13.1.1. DBMS_JOB Programs, Oracle Built-in Packages
CHK_OPTION column, *_POLICIES data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
CHOOSE_DATE procedure: 7.4.1.3. Representing dates, Oracle Web Applications
CHR function: 11.1.2. The CHR function, Oracle PL/SQL Programming
CLASSPATH
9.2.1. Installing Java, Guide to Oracle8i Features
9.3.2. Building a Custom Java Class, Guide to Oracle8i Features
CLEAR_PLSQL_TRACE procedure, DBMS_TRACE package: 7.2.2. DBMS_TRACE Programs , Guide to Oracle8i Features
CLOB datatype
1.4.7.6. Large object support, Oracle PL/SQL Programming
4.2.7.3. The CLOB datatype, Oracle PL/SQL Programming
EMPTY_CLOB function: 13.2.3. The EMPTY_CLOB function, Oracle PL/SQL Programming
CLOB_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages
CLOBs
7.5.1. The TO_LOB Function, Guide to Oracle8i Features
8.2.1. LOB Datatypes, Oracle Built-in Packages
8.2.1.4. The CLOB datatype, Oracle Built-in Packages
CLOSE statement
(see also cursors)
6.2.2. Cursor Operations, Oracle PL/SQL Programming
6.8. Closing Cursors, Oracle PL/SQL Programming
cursors: 4.3. Multirow Queries with Cursor Variables, Guide to Oracle8i Features
CLOSE_CURSOR procedure
2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.9.1. The DBMS_SQL.CLOSE_CURSOR procedure, Oracle Built-in Packages
C.14.3. The CLOSE_CURSOR procedure, Oracle PL/SQL Programming
CLOSE_DATABASE_LINK procedure
11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
11.1.4.1. The DBMS_SESSION.CLOSE_DATABASE_LINK procedure, Oracle Built-in Packages
C.12.1. The CLOSE_DATABASE_LINK procedure, Oracle PL/SQL Programming
COBOL
1.2.2. Application Development, Oracle Web Applications
1.3.10. Advanced Queuing, Oracle Web Applications
6. PL/SQL, Oracle Web Applications
COLUMN_VALUE procedure
2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure, Oracle Built-in Packages
C.14.4. The COLUMN_VALUE procedure, Oracle PL/SQL Programming
Method 4 dynamic SQL and: 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL, Oracle Built-in Packages
COLUMN_VALUE_CHAR procedure: 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure, Oracle Built-in Packages
COLUMN_VALUE_LONG procedure
2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.8.2. The DBMS_SQL.COLUMN_VALUE_LONG procedure, Oracle Built-in Packages
COLUMN_VALUE_RAW procedure: 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure, Oracle Built-in Packages
COLUMN_VALUE_ROWID procedure: 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure, Oracle Built-in Packages
COM: 1.2.3. Application Integration and Electronic Data Interchange (EDI), Oracle Web Applications
COMMA_TO_TABLE procedure
10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.4. The DBMS_UTILITY.COMMA_TO_TABLE procedure, Oracle Built-in Packages
C.16.2. The COMMA_TO_TABLE procedure, Oracle PL/SQL Programming
COMMENT keyword: 6.1.1. The COMMIT Statement, Oracle PL/SQL Programming
COMMENT_ON_<conflicttype>_RESOLUTION procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.5.1.3. The DBMS_REPCAT.COMMENT_ON_<conflicttype>_RESOLUTION procedure, Oracle Built-in Packages
COMMENT_ON_COLUMN_GROUP procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.2.3.3. The DBMS_REPCAT.COMMENT_ON_COLUMN_GROUP procedure, Oracle Built-in Packages
COMMENT_ON_DELETE_RESOLUTION procedure: 16.5.1.3. The DBMS_REPCAT.COMMENT_ON_<conflicttype>_RESOLUTION procedure, Oracle Built-in Packages
COMMENT_ON_PRIORITY_GROUP procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.3.2.3. The DBMS_REPCAT.COMMENT_ON_PRIORITY_GROUP procedure, Oracle Built-in Packages
COMMENT_ON_REPGROUP procedure
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.2.3. The DBMS_REPCAT.COMMENT_ON_REPGROUP procedure, Oracle Built-in Packages
COMMENT_ON_REPOBJECT procedure
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.3.6. The DBMS_REPCAT.COMMENT_ON_REPOBJECT procedure, Oracle Built-in Packages
COMMENT_ON_REPSITES procedure
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.5.3. The DBMS_REPCAT.COMMENT_ON_REPSITES procedure, Oracle Built-in Packages
COMMENT_ON_SITE_PRIORITY procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.4.2.3. The DBMS_REPCAT.COMMENT_ON_SITE_PRIORITY procedure, Oracle Built-in Packages
COMMENT_ON_UNIQUE_RESOLUTION procedure: 16.5.1.3. The DBMS_REPCAT.COMMENT_ON_<conflicttype>_RESOLUTION procedure, Oracle Built-in Packages
COMMENT_ON_UPDATE_RESOLUTION procedure: 16.5.1.3. The DBMS_REPCAT.COMMENT_ON_<conflicttype>_RESOLUTION procedure, Oracle Built-in Packages
COMMIT procedure
(see also DBMS_PIPE)
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.3.1. The DBMS_TRANSACTION.COMMIT procedure, Oracle Built-in Packages
C.10. DBMS_PIPE, Oracle PL/SQL Programming
C.15.4. The COMMIT procedure , Oracle PL/SQL Programming
COMMIT statement
2.5.2. Using Autonomous Transactions in a Database Trigger, Guide to Oracle8i Features
6.1.1. The COMMIT Statement, Oracle PL/SQL Programming
6.11.1. Releasing Locks with COMMIT, Oracle PL/SQL Programming
COMMIT_COMMENT procedure
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.3.2. The DBMS_TRANSACTION.COMMIT_COMMENT procedure, Oracle Built-in Packages
C.15.5. The COMMIT_COMMENT procedure , Oracle PL/SQL Programming
COMMIT_FORCE procedure
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.3.3. The DBMS_TRANSACTION.COMMIT_FORCE procedure, Oracle Built-in Packages
C.15.6. The COMMIT_FORCE procedure, Oracle PL/SQL Programming
COMMIT_WORK procedure (DBMS_DEFER)
17.3.1.1. DBMS_DEFER programs, Oracle Built-in Packages
17.3.2.3. The DBMS_DEFER.COMMIT_WORK procedure, Oracle Built-in Packages
COMMON schema: 4.6.1. Sharing NDS Programs with Invoker Rights, Guide to Oracle8i Features
COMPARE function: C.6.2. The COMPARE function, Oracle PL/SQL Programming
COMPARE function (DBMS_LOB)
8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.2.1. The DBMS_LOB.COMPARE function, Oracle Built-in Packages
COMPARE function (UTL_RAW): 9.2.3.7. The UTL_RAW.COMPARE function, Oracle Built-in Packages
COMPILE_SCHEMA procedure
10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.5. The DBMS_UTILITY.COMPILE_SCHEMA procedure, Oracle Built-in Packages
C.16.3. The COMPILE_SCHEMA procedure, Oracle PL/SQL Programming
CONCAT function
9.2.3.8. The UTL_RAW.CONCAT function, Oracle Built-in Packages
4.3.3. Function Results with NULL Arguments, Oracle PL/SQL Programming
11.1.3. The CONCAT function, Oracle PL/SQL Programming
CONNECT command: 7.1.2. Displaying Dates, Advanced Oracle PL/SQL Programming with Packages
CONSTANT declaration: 1.6.1.4. Remove hard-coded literals from your application, Advanced Oracle PL/SQL Programming with Packages
CONVERT function
4.1.1.1. DBMS_LOCK programs, Oracle Built-in Packages
4.1.2.3. The DBMS_LOCK.CONVERT function, Oracle Built-in Packages
9.2.3.9. The UTL_RAW.CONVERT function, Oracle Built-in Packages
C.7.2. The CONVERT function, Oracle PL/SQL Programming
14.2.2. The CONVERT function, Oracle PL/SQL Programming
COPIES function: 9.2.3.10. The UTL_RAW.COPIES function, Oracle Built-in Packages
COPY procedure
C.6.3. The COPY procedure, Oracle PL/SQL Programming
Oracle Developer's FormsBuilder: 4.6.3. Dynamic PL/SQL , Guide to Oracle8i Features
COPY procedure (DBMS_DEFER_SYS)
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.3. Copying Deferred Transactions to New Destinations, Oracle Built-in Packages
COPY procedure (DBMS_LOB)
8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.3.2. The DBMS_LOB.COPY procedure, Oracle Built-in Packages
7.5.2.5. Managing temporary LOBs, Guide to Oracle8i Features
CORBA: 1.2.3. Application Integration and Electronic Data Interchange (EDI), Oracle Web Applications
CORBA server objects: 1.3.7. Java, Oracle Web Applications
COS function: 13.1.7. The COS function, Oracle PL/SQL Programming
COSH function: 13.1.8. The COSH function, Oracle PL/SQL Programming
COUNT function
10.8.2.1. The COUNT function, Oracle PL/SQL Programming
19.6.1. COUNT, Oracle PL/SQL Programming
CPU time: (see performance)
CREATE ANY CONTEXT system privilege: 8.2. CREATE CONTEXT: Creating Contexts, Guide to Oracle8i Features
CREATE ANY TRIGGER system privilege: 6.3. Schema-Level Event Triggers, Guide to Oracle8i Features
CREATE CONTEXT statement: 8.1. FGAC Components, Guide to Oracle8i Features
CREATE DIRECTORY command: 4.2.7.7. Working with BFILEs, Oracle PL/SQL Programming
CREATE JAVA statement: 9.1. Oracle8i and Java, Guide to Oracle8i Features
CREATE LIBRARY command
21.2.3. Step 3: Issue CREATE LIBRARY Statement, Oracle PL/SQL Programming
21.3.1. CREATE LIBRARY: Creating the External Procedure Library, Oracle PL/SQL Programming
CREATE OR REPLACE
17.5.2. Locating Text in the Data Dictionary, Advanced Oracle PL/SQL Programming with Packages
23.5.3. Changing Stored Objects, Oracle PL/SQL Programming
19.4.1.7. Compiling source code with PLVdyn, Advanced Oracle PL/SQL Programming with Packages
CREATE TABLE statement, dynamic SQL
4. Native Dynamic SQL in Oracle8i, Guide to Oracle8i Features
4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features
CREATE TYPE BODY statement: 18.3.3. CREATE TYPE BODY: Creating a Body, Oracle PL/SQL Programming
CREATE TYPE command: 19.2. Creating the New Collections, Oracle PL/SQL Programming
CREATE TYPE ... AS OBJECT statement: 19.2.1.2. Collection as an attribute of an object type, Oracle PL/SQL Programming
CREATE TYPE statement: 18.3.2. CREATE TYPE and DROP TYPE: Creating and Dropping Types, Oracle PL/SQL Programming
CREATE VIEW statement: 20.3.1. CREATE VIEW: Creating an Object View, Oracle PL/SQL Programming
CREATE command
23.5.1. Creating Stored Objects, Oracle PL/SQL Programming
6.3. Schema-Level Event Triggers, Guide to Oracle8i Features
CREATE events
1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
6. New Trigger Features in Oracle8i, Guide to Oracle8i Features
CREATE$JAVA$LOB$TABLE element, loadjava utility: 9.4. Using loadjava, Guide to Oracle8i Features
CREATETEMPORARY procedure, DBMS_LOB package: 7.5.2.1. CREATETEMPORARY: Creating a temporary LOB, Guide to Oracle8i Features
CREATE_MASTER_REPGROUP procedure
15.3.2.1. The DBMS_REPCAT.CREATE_MASTER_REPGROUP procedure, Oracle Built-in Packages
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
CREATE_MASTER_REPOBJECT procedure
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.3.1. The DBMS_REPCAT.CREATE_MASTER_REPOBJECT procedure, Oracle Built-in Packages
CREATE_PIPE function
3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.3.1. The DBMS_PIPE.CREATE_PIPE function, Oracle Built-in Packages
CREATE_QUEUE procedure
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.2.1. The DBMS_AQADM.CREATE_QUEUE procedure, Oracle Built-in Packages
C.3.2.3. The CREATE_QUEUE procedure, Oracle PL/SQL Programming
CREATE_QUEUE_TABLE procedure
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.1.2. The DBMS_AQADM.CREATE_QUEUE_TABLE procedure, Oracle Built-in Packages
C.3.2.1. The CREATE_QUEUE_TABLE procedure, Oracle PL/SQL Programming
LOB storage and: 5.3.3. Queue Type Names, Oracle Built-in Packages
CREATE_QUEUE_TABLE procedure, DBMS_AQADM package: 7.6.1. CREATE_QUEUE_TABLE and MIGRATE_QUEUE_TABLE: Setting Version Compatibility and Queue Migration, Guide to Oracle8i Features
CREATE_SNAPSHOT_REPGROUP procedure
14.4.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
14.4.2.1. The DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP procedure, Oracle Built-in Packages
CREATE_SNAPSHOT_REPOBJECT procedure
14.4.3.1. The DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT procedure, Oracle Built-in Packages
14.4.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
CURRENT_INSTANCE function, DBMS_UTILITY package: 7.7.1. CURRENT_INSTANCE: Returning the Instance Number, Guide to Oracle8i Features
CURRENT_SCHEMA attribute, SYS_CONTEXT function: 8.4.1. The SYS_CONTEXT Function, Guide to Oracle8i Features
CURRENT_SCHEMAID attribute, SYS_CONTEXT function: 8.4.1. The SYS_CONTEXT Function, Guide to Oracle8i Features
CURRENT_USER option, AUTHID clause: 3.2.1. Invoker Rights Syntax, Guide to Oracle8i Features
CURRENT_USERID attribute, SYS_CONTEXT function: 8.4.1. The SYS_CONTEXT Function, Guide to Oracle8i Features
CURSOR statement: 6.4. Declaring Cursors, Oracle PL/SQL Programming
CURSOR_ALREADY_OPEN exception: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming
Companion Utilities Guide (diskette)
A. What's on the Companion Disk?, Oracle Built-in Packages
About the Disk, Oracle Built-in Packages
A. Appendix: What's on the Companion Disk?, Guide to Oracle8i Features
About the Disk, Guide to Oracle8i Features
Cooperative Development Environment (CDE): 1.2. The Concept of Programming in Oracle Applications, Oracle PL/SQL Programming
c_PLVlogsp constant: 21.1.5.3. Types of rollback activity, Advanced Oracle PL/SQL Programming with Packages
c_after constant: 5.13.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_all constant: 5.21.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_all_tokens constant: 5.22.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_append constant: 5.11.1. Package constants and exceptions, Advanced Oracle PL/SQL Programming with Packages
c_before constant: 5.13.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_bi_tokens constant: 5.22.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_both constant: 5.13.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_datemask constant
5.3.1. PL/Vision constants, Advanced Oracle PL/SQL Programming with Packages
6.2. Setting the PL/Vision Date Mask, Advanced Oracle PL/SQL Programming with Packages
c_def_length constant: 5.13.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_default constant: 21.1.5.3. Types of rollback activity, Advanced Oracle PL/SQL Programming with Packages
c_delim constant
5.21.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
21.1.4. Managing a PL/SQL Table Log, Advanced Oracle PL/SQL Programming with Packages
c_dosdelim constant
5.11.1. Package constants and exceptions, Advanced Oracle PL/SQL Programming with Packages
13.2.1. Setting the Operating System Delimiter, Advanced Oracle PL/SQL Programming with Packages
c_examples constant: 5.14.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_go constant
5.10.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
22.1.4. Exception Handling Actions, Advanced Oracle PL/SQL Programming with Packages
c_ignore_case constant: 5.21.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_incr_indent constant: 5.13.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_indent constant: 5.13.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_int_no_change constant: 5.12.1. Package Constants, Advanced Oracle PL/SQL Programming with Packages
c_kw_tokens constant: 5.22.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_last constant: 21.1.5.3. Types of rollback activity, Advanced Oracle PL/SQL Programming with Packages
c_last_pos constant: 5.28.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_leph constant
5.20.6. Programmatic cursor FOR loop elements, Advanced Oracle PL/SQL Programming with Packages
11.7. A Programmatic Cursor FOR Loop, Advanced Oracle PL/SQL Programming with Packages
11.7.2. Constructing the Execution String, Advanced Oracle PL/SQL Programming with Packages
c_literal constant: 5.13.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_main constant: 5.14.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_modname constant
5.20.6. Programmatic cursor FOR loop elements, Advanced Oracle PL/SQL Programming with Packages
11.7. A Programmatic Cursor FOR Loop, Advanced Oracle PL/SQL Programming with Packages
c_modspec constant
5.20.6. Programmatic cursor FOR loop elements, Advanced Oracle PL/SQL Programming with Packages
11.7. A Programmatic Cursor FOR Loop, Advanced Oracle PL/SQL Programming with Packages
c_no_change constant: 5.12.1. Package Constants, Advanced Oracle PL/SQL Programming with Packages
c_noaction constant: 21.1.5.3. Types of rollback activity, Advanced Oracle PL/SQL Programming with Packages
c_none constant
5.13.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
21.1.5.3. Types of rollback activity, Advanced Oracle PL/SQL Programming with Packages
c_nonkw_tokens constant: 5.22.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_nousecor constant: 5.4.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_prefix constant
5.2.3. Setting the line prefix, Advanced Oracle PL/SQL Programming with Packages
5.12.1. Package Constants, Advanced Oracle PL/SQL Programming with Packages
7.3. The Output Prefix , Advanced Oracle PL/SQL Programming with Packages
c_read constant: 5.11.1. Package constants and exceptions, Advanced Oracle PL/SQL Programming with Packages
c_recNgo constant
5.10.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
22.1.4. Exception Handling Actions, Advanced Oracle PL/SQL Programming with Packages
c_recNstop constant
5.10.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
22.1.4. Exception Handling Actions, Advanced Oracle PL/SQL Programming with Packages
c_respect_case constant: 5.21.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_show_object constant
5.20.6. Programmatic cursor FOR loop elements, Advanced Oracle PL/SQL Programming with Packages
11.7. A Programmatic Cursor FOR Loop, Advanced Oracle PL/SQL Programming with Packages
11.7.2. Constructing the Execution String, Advanced Oracle PL/SQL Programming with Packages
c_stop constant
5.10.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
22.1.4. Exception Handling Actions, Advanced Oracle PL/SQL Programming with Packages
c_suffix constant: 5.12.1. Package Constants, Advanced Oracle PL/SQL Programming with Packages
c_top_pos constant
5.28.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
21.2.4.7. Retrieving stack contents, Advanced Oracle PL/SQL Programming with Packages
c_unixdelim constant
5.11.1. Package constants and exceptions, Advanced Oracle PL/SQL Programming with Packages
13.2.1. Setting the Operating System Delimiter, Advanced Oracle PL/SQL Programming with Packages
c_usecor constant: 5.4.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_word constant: 5.21.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
c_write constant: 5.11.1. Package constants and exceptions, Advanced Oracle PL/SQL Programming with Packages
cache parameter, CREATETEMPORARY procedure: 7.5.2.1. CREATETEMPORARY: Creating a temporary LOB, Guide to Oracle8i Features
calc_totals procedure: 22.1.6.5. Integrating PLVexc with PLVtrc , Advanced Oracle PL/SQL Programming with Packages
calendar: (see date)
calendar format (NLS), setting: 11.1.2.3. The DBMS_SESSION.SET_NLS procedure, Oracle Built-in Packages
calendar wizard, WebDB: 3.1.2.2. Building user interface components , Oracle Web Applications
calibrate procedure: 5.27.6. Calibration and timing scripts, Advanced Oracle PL/SQL Programming with Packages
call specs: 9.8.1. Call Specs, Guide to Oracle8i Features
call stack, returning: 10.1.2.10. The DBMS_UTILITY.FORMAT_CALL_STACK function, Oracle Built-in Packages
calltype function: 6.3.1. Using the assert Procedure, Advanced Oracle PL/SQL Programming with Packages
capitalization
2.2. Using Effective Coding Style for Packages, Advanced Oracle PL/SQL Programming with Packages
15.4.1. How to Find Source Code, Advanced Oracle PL/SQL Programming with Packages
18.1. PLVcase: Converting the Case of PL/SQL Programs, Advanced Oracle PL/SQL Programming with Packages
case sensitivity: 2.5.2. Making Your Programs Case-Insensitive, Advanced Oracle PL/SQL Programming with Packages
capture procedure
5.27.4. Capturing the current timestamp, Advanced Oracle PL/SQL Programming with Packages
14.2. Capturing the Start Time, Advanced Oracle PL/SQL Programming with Packages
carriage returns: (see newline markers)
cartridges
2.3. When to Use Autonomous Transactions, Guide to Oracle8i Features
4.1.3.1. Cartridges, Oracle Web Applications
case
INITCAP function: 11.1.4. The INITCAP function, Oracle PL/SQL Programming
LOWER function: 11.1.7. The LOWER function, Oracle PL/SQL Programming
UPPER function: 11.1.16. The UPPER function, Oracle PL/SQL Programming
and readability: 3.1.2. Using Case to Aid Readability, Oracle PL/SQL Programming
consistency of: 22.7.4. Ensure Case Consistency of Parameters, Oracle PL/SQL Programming
sensitivity
2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
2.3. Literals, Oracle PL/SQL Programming
case sensitivity: 2.5.2. Making Your Programs Case-Insensitive, Advanced Oracle PL/SQL Programming with Packages
casting: (see conversions; specific CAST functions)
casting collections: 19.5.2.1. Casting a named collection, Oracle PL/SQL Programming
cataloging code: 18.2. PLVcat: Cataloguing PL/SQL Source Code, Advanced Oracle PL/SQL Programming with Packages
categories, WebDB: 3.1.3.2. Managing content, Oracle Web Applications
caterr.sql : 15.3.6.3. The DBMS_REPCAT.PURGE_MASTER_LOG procedure, Oracle Built-in Packages
catjobq.sql script: 13.1. Getting Started with DBMS_ JOB, Oracle Built-in Packages
catlog.sql : 15.3.6.1. The DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN procedure, Oracle Built-in Packages
catoctk.sql script: 10.4.1. Getting Started with DBMS_RANDOM, Oracle Built-in Packages
catqueue.sql file: 5.6.1.1. The database table for queue data, Oracle Built-in Packages
catrep.sql script
16.1. Getting Started with DBMS_REPCAT, Oracle Built-in Packages
17.2.1. Getting Started with DBMS_DEFER_SYS, Oracle Built-in Packages
17.3.1. Getting Started with DBMS_DEFER, Oracle Built-in Packages
17.4.1. Getting Started with DBMS_DEFER_QUERY, Oracle Built-in Packages
century: (see date)
certification authority (CA): 2.5.5. Additional Security Precautions, Oracle Web Applications
cfloop procedure
5.13.10. Miscellaneous code generators, Advanced Oracle PL/SQL Programming with Packages
16.2.8. Generating a Cursor FOR Loop, Advanced Oracle PL/SQL Programming with Packages
change_it_again procedure: 5.7.8.2. Overriding with a recipient list, Oracle Built-in Packages
char_name function: 5.6.3. Other functions and procedures, Advanced Oracle PL/SQL Programming with Packages
character datatypes in overloaded modules: 15.8.4. Restrictions on Overloading, Oracle PL/SQL Programming
character functions: 11. Character Functions, Oracle PL/SQL Programming
character large objects: (see CLOBs; NCLOBs)
character sets: 14.2.2. The CONVERT function, Oracle PL/SQL Programming
National Language Support, conversions for: 9.2.3.9. The UTL_RAW.CONVERT function, Oracle Built-in Packages
fixed-width
8.2.1.4. The CLOB datatype, Oracle Built-in Packages
8.2.1.5. The NCLOB datatype, Oracle Built-in Packages
variable-width
8.2.1.4. The CLOB datatype, Oracle Built-in Packages
8.2.1.5. The NCLOB datatype, Oracle Built-in Packages
characters
NLS datatypes for: 4.2.6. NLS Character Datatypes, Oracle PL/SQL Programming
adding to strings: 11.1.11. The RPAD function, Oracle PL/SQL Programming
converting to numbers, package for: 17.8.7. Recursive Processing in a SQL Statement, Oracle PL/SQL Programming
datatypes for: 4.2.3. Character Datatypes, Oracle PL/SQL Programming
extracting from strings: 11.1.14. The SUBSTR function, Oracle PL/SQL Programming
line separator: 7.2. The Line Separator, Advanced Oracle PL/SQL Programming with Packages
replacing in strings
11.1.10. The REPLACE function, Oracle PL/SQL Programming
11.1.15. The TRANSLATE function, Oracle PL/SQL Programming
string: 5.6. PLVchr: Operations on Single Characters, Advanced Oracle PL/SQL Programming with Packages
stripping from strings
11.1.12. The RTRIM function, Oracle PL/SQL Programming
11.1.9. The LTRIM function, Oracle PL/SQL Programming
word wrap: 11.2.2. Implementing Word Wrap for Long Text, Oracle PL/SQL Programming
chart wizard, WebDB: 3.1.2.2. Building user interface components , Oracle Web Applications
checking
existence, with Record Found? function: 16.2.7. Generating a "Record Found?" Function, Advanced Oracle PL/SQL Programming with Packages
existence of files: 13.3. Creating and Checking Existence of Files, Advanced Oracle PL/SQL Programming with Packages
last PLVobj cursor record: 11.4.3. Checking for Last Record, Advanced Oracle PL/SQL Programming with Packages
for NULL values: 4.3.2. Checking for NULL Values, Oracle PL/SQL Programming
for specific errors, triggers: 6.2.1.4. Checking for specific errors, Guide to Oracle8i Features
input: 3.8.1. When the num_in Argument Is 0, Advanced Oracle PL/SQL Programming with Packages
child block: (see nested blocks)
child records: (see records)
class instances: 18.1.4.2. Classification , Oracle PL/SQL Programming
classes: (see object types)
classification of objects: 18.1.4.2. Classification , Oracle PL/SQL Programming
clear_bailouts procedure
5.10.7. Bailing out program execution, Advanced Oracle PL/SQL Programming with Packages
22.1.10.1. Managing the bailout error list, Advanced Oracle PL/SQL Programming with Packages
clear_pstab procedure
5.17.6. Managing the log , Advanced Oracle PL/SQL Programming with Packages
21.1.4.1. Counting and clearing the PL/SQL table, Advanced Oracle PL/SQL Programming with Packages
clearecs procedure
5.28.8. Accessing the PLVtrc execution call stack (ECS), Advanced Oracle PL/SQL Programming with Packages
21.2.4.5. Emptying the stack, Advanced Oracle PL/SQL Programming with Packages
clearing: (see deleting)
clearing tables: 10.7. Clearing the PL/SQL Table, Oracle PL/SQL Programming
client information
registering: 7.2.4. The DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure, Oracle Built-in Packages
returning: 7.2.1. The DBMS_APPLICATION_INFO.READ_CLIENT_INFO procedure, Oracle Built-in Packages
client-side SQL: 25.3.3. Avoid Client-Side SQL, Oracle PL/SQL Programming
client-side applications: 4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features
client-side packages: 1.2.2. The Client-Side Layers, Advanced Oracle PL/SQL Programming with Packages
client_info procedure: 7.3.1. About the register_app Package, Oracle Built-in Packages
client_request procedure: 3.1.7.5. The pipesvr package, Oracle Built-in Packages
clients, types of: 1.1. The Internet Grows Up, Oracle Web Applications
clock: (see time)
close_item procedure: 3.2.3.5. The auction package, Oracle Built-in Packages
close_links procedure
11.1.5.1. Adding value to DBMS_SESSION, Oracle Built-in Packages
11.1.5.5. The close_links procedure, Oracle Built-in Packages
close_objects procedure
5.20.5. Interfacing with the PLVobj cursor, Advanced Oracle PL/SQL Programming with Packages
11.4.1. Opening and Closing the PLVobj Cursor, Advanced Oracle PL/SQL Programming with Packages
closepipe function: 3.1.3.2. The DBMS_PIPE.REMOVE_PIPE function, Oracle Built-in Packages
closesrc procedure
5.15.4. Managing the source repository, Advanced Oracle PL/SQL Programming with Packages
12.9.1. Closing the Source, Advanced Oracle PL/SQL Programming with Packages
closetrg procedure
5.15.6. Managing the target repository, Advanced Oracle PL/SQL Programming with Packages
12.9.2. Closing the Target, Advanced Oracle PL/SQL Programming with Packages
closing
cursors: 6.8. Closing Cursors, Oracle PL/SQL Programming
PLVobj cursor: 11.4.1. Opening and Closing the PLVobj Cursor, Advanced Oracle PL/SQL Programming with Packages
files
13.4. Opening and Closing Files, Advanced Oracle PL/SQL Programming with Packages
21.1.3.2. Closing the file, Advanced Oracle PL/SQL Programming with Packages
5.11.8. Closing a file, Advanced Oracle PL/SQL Programming with Packages
repository: 12.9.1. Closing the Source, Advanced Oracle PL/SQL Programming with Packages
clrtrg procedure
5.15.6. Managing the target repository, Advanced Oracle PL/SQL Programming with Packages
12.9.3. Clearing the Target, Advanced Oracle PL/SQL Programming with Packages
cluster segments, space utilization: 12.1. DBMS_SPACE: Obtaining Space Information, Oracle Built-in Packages
code
(see also programming technique, coding)
1.2.1. The Iceberg Approach to Coding, Advanced Oracle PL/SQL Programming with Packages
PL/SQL repositories: 12. PLVio: Reading and Writing PL/SQL Source Code, Advanced Oracle PL/SQL Programming with Packages
PLVtmr package with: 14.4. Using PLVtmr in Scripts, Advanced Oracle PL/SQL Programming with Packages
author: 16.3.2. Setting the Code Author, Advanced Oracle PL/SQL Programming with Packages
cataloging: 18.2. PLVcat: Cataloguing PL/SQL Source Code, Advanced Oracle PL/SQL Programming with Packages
compiled, tuning access to: 25.2. Tuning Access to Compiled Code, Oracle PL/SQL Programming
compiling: 15. PLVvu: Viewing Source Code and Compile Errors, Advanced Oracle PL/SQL Programming with Packages
with PLVdyn package: 19.4.1.7. Compiling source code with PLVdyn, Advanced Oracle PL/SQL Programming with Packages
consolidating: 2.9.2. Lava Lamp Code Consolidation, Advanced Oracle PL/SQL Programming with Packages
converting case of: 18.1.2. A Script to Convert Programs, Advanced Oracle PL/SQL Programming with Packages
converting to PL/SQL programs: 4.4.3. Converting Scripts to PL/SQL Programs, Advanced Oracle PL/SQL Programming with Packages
created during installation: 4.6. Summary of Files on Disk, Advanced Oracle PL/SQL Programming with Packages
critical, pinning into SGA: 25.2.2. Pin Critical Code into the SGA, Oracle PL/SQL Programming
customizing for users: 2.8.1.2. Fitting the program to the user , Advanced Oracle PL/SQL Programming with Packages
debugging/testing: 22.1. The Challenge of Exception Handling, Advanced Oracle PL/SQL Programming with Packages
development: 3. The PL/SQL Development Spiral, Advanced Oracle PL/SQL Programming with Packages
displaying: 15.2.2. Setting the Code Overlap, Advanced Oracle PL/SQL Programming with Packages
dynamic PL/SQL: 19.5.5. Executing Dynamic PL/SQL Code, Advanced Oracle PL/SQL Programming with Packages
elapsed time of: 5.27. PLVtmr: Program Performance Analyzer, Advanced Oracle PL/SQL Programming with Packages
encrypting: 23.7. Encrypting Stored Code, Oracle PL/SQL Programming
execution time of: (see performance)
finding source code: 15.4.1. How to Find Source Code, Advanced Oracle PL/SQL Programming with Packages
for testing code: 4.6.2. Contents of the test Subdirectory, Advanced Oracle PL/SQL Programming with Packages
generating
5.13. PLVgen: PL/SQL Code Generator, Advanced Oracle PL/SQL Programming with Packages
16. PLVgen: Generating PL/SQL Programs, Advanced Oracle PL/SQL Programming with Packages
generation toggles: 2.6.2. Toggles for Code Generation, Advanced Oracle PL/SQL Programming with Packages
halting execution of: 5.10.6. Exception handlers, Advanced Oracle PL/SQL Programming with Packages
implementing windows: 2.7.3. Implementing the Window, Advanced Oracle PL/SQL Programming with Packages
layers of: (see packages)
line numbers: 16.3.8. Generating Line Numbers, Advanced Oracle PL/SQL Programming with Packages
memory-based architecture: 23.1.3. Memory-Based Architecture of PL/SQL Code , Oracle PL/SQL Programming
overloading programs: 2.8. Overloading for Smart Packages, Advanced Oracle PL/SQL Programming with Packages
parallelization: 1.5.1.1. Leveraging builtin packages, Advanced Oracle PL/SQL Programming with Packages
parsing
5.22. PLVprsps: PL/SQL Source Code Parsing, Advanced Oracle PL/SQL Programming with Packages
10.3.2. Parsing PL/SQL Code, Advanced Oracle PL/SQL Programming with Packages
program name: 11.3.2. Converting the Program Name, Advanced Oracle PL/SQL Programming with Packages
pausing programs: 5.3.6. Miscellaneous programs, Advanced Oracle PL/SQL Programming with Packages
pinning into memory: 1.4.3.1. Managing packages in shared memory, Advanced Oracle PL/SQL Programming with Packages
procedural, avoiding: 25.3.5. Avoid Procedural Code When Possible , Oracle PL/SQL Programming
redundant: (see redundancy)
repetetive: (see redundancy)
reusing: 1.7.1. Write as Little Code as Possible, Oracle PL/SQL Programming
1.2.1. The Iceberg Approach to Coding
4.1.1. The Benefits of PL/Vision
shared, executing: 23.1. Executing Stored Code, Oracle PL/SQL Programming
size restrictions: 1.6.4. Working with Large Packages, Advanced Oracle PL/SQL Programming with Packages
standard header: 16.3.3. Using the Program Header, Advanced Oracle PL/SQL Programming with Packages
stored: 5.29. PLVvu: Code and Error Viewing , Advanced Oracle PL/SQL Programming with Packages
structuring of: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming
style of: 1.7.4. Standardize Your PL/SQL Development Environment, Oracle PL/SQL Programming
testing
24.2.5. Change and Test One Area of Code at a Time, Oracle PL/SQL Programming
4.1.1. The Benefits of PL/Vision, Advanced Oracle PL/SQL Programming with Packages
tracing: 16.3.4. Using the Program Trace , Advanced Oracle PL/SQL Programming with Packages
upgrades and fixes: 1.6.1.6. Hide weaknesses to facilitate upgrades and fixes., Advanced Oracle PL/SQL Programming with Packages
code procedure
5.29.3. Displaying stored code, Advanced Oracle PL/SQL Programming with Packages
15.4.1. How to Find Source Code, Advanced Oracle PL/SQL Programming with Packages
17.2. Current Sources of Information, Advanced Oracle PL/SQL Programming with Packages
code_after procedure
5.29.3. Displaying stored code, Advanced Oracle PL/SQL Programming with Packages
15.3.2. Displaying Code by Keyword, Advanced Oracle PL/SQL Programming with Packages
17.2. Current Sources of Information, Advanced Oracle PL/SQL Programming with Packages
codependency, package: 2.4.1. Creating Codependent Packages, Advanced Oracle PL/SQL Programming with Packages
coding: 1.2. The Concept of Programming in Oracle Applications, Oracle PL/SQL Programming
analyzing size of: 23.6.3. Analyzing the Size of PL/SQL Code, Oracle PL/SQL Programming
anticipating errors: (see exceptions)
avoiding repetitive: 22.3. Take Full Advantage of Local Modularization, Oracle PL/SQL Programming
comments in: (see comments)
considering parameter case: 22.7.4. Ensure Case Consistency of Parameters, Oracle PL/SQL Programming
creating independent modules: 22.5. Create Independent Modules, Oracle PL/SQL Programming
cross-referencing source code: 23.6.5. Cross-Referencing Source Code, Oracle PL/SQL Programming
documenting: 24.2.6. Document and Back Up Your Efforts, Oracle PL/SQL Programming
errors: (see errors; exceptions)
finding strings in: 23.6.4. Displaying and Searching Source Code, Oracle PL/SQL Programming
hints for effective
1.5. Advice for Oracle Programmers, Oracle PL/SQL Programming
3. Effective Coding Style, Oracle PL/SQL Programming
4.2.8.3. Drawbacks of implicit conversions, Oracle PL/SQL Programming
22. Code Design Tips, Oracle PL/SQL Programming
IF statements: 5.1.4. Nested IF Statements, Oracle PL/SQL Programming
commenting: 3.6. Using Comments Effectively, Oracle PL/SQL Programming
exception handling: 8.10. RAISE Nothing but Exceptions, Oracle PL/SQL Programming
loops: 7.7. Tips for PL/SQL Loops, Oracle PL/SQL Programming
nested records: 9.7.1. Example of Nested Records, Oracle PL/SQL Programming
parameters: 22.7. Tips for Parameter Design, Oracle PL/SQL Programming
records: 9.1.3.3. Leaner, cleaner code, Oracle PL/SQL Programming
in databases: 23. Managing Code in the Database, Oracle PL/SQL Programming
increasing readability of code: 5.2.2.1. Improving the readability of your program , Oracle PL/SQL Programming
layout of: 3.1. Fundamentals of Effective Layout, Oracle PL/SQL Programming
recursive processing: 17.8.7. Recursive Processing in a SQL Statement, Oracle PL/SQL Programming
removing unused variables: 4.7.6. Remove Unused Variables from Programs, Oracle PL/SQL Programming
sequential processing: 17.8.6. Sequential Processing Against a Column's Value, Oracle PL/SQL Programming
simplifying logic with variables: 4.7.9. Use Variables to Hide Complex Logic, Oracle PL/SQL Programming
testing programs: 2.5.2. Multiline Comment Syntax, Oracle PL/SQL Programming
coercions: 9.2.2.1. Conversion and coercion, Oracle Built-in Packages
collected data, formats: 7.2.4. Format of Collected Data , Guide to Oracle8i Features
collections
4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features
5. Bulking Up with PL/SQL 8.1, Guide to Oracle8i Features
10.4. SQL Operations on Collections, Guide to Oracle8i Features
PL/SQL-to-server integration example: 19.7. Example: PL/SQL-to-Server Integration, Oracle PL/SQL Programming
VARRAYs: (see VARRAYs)
adding/removing elements from: 19.4.3. Adding and Removing Elements, Oracle PL/SQL Programming
built-in methods for: 19.6. Collection Built-Ins, Oracle PL/SQL Programming
casting: 19.5.2.1. Casting a named collection, Oracle PL/SQL Programming
choosing which kind to use: 19.9. Which Collection Type Should I Use?, Oracle PL/SQL Programming
collection variables
19.2.2.1. Collection variables, Oracle PL/SQL Programming
19.4.1. Initializing Collection Variables, Oracle PL/SQL Programming
comparing: 19.4.4. Comparing Collections, Oracle PL/SQL Programming
creating: 19.2. Creating the New Collections, Oracle PL/SQL Programming
data dictionary entries for: 19.8.2. Data Dictionary, Oracle PL/SQL Programming
declaring as datatype: 19.2.2. Collections in PL/SQL, Oracle PL/SQL Programming
index-by tables: (see index-by tables)
nested tables: (see nested tables)
passing arguments of: 19.8.3. Call by Reference or Call by Value, Oracle PL/SQL Programming
privileges: 19.8.1. Privileges, Oracle PL/SQL Programming
pseudo-functions: 19.5. Collection Pseudo-Functions, Oracle PL/SQL Programming
types of: 19.1. Types of Collections, Oracle PL/SQL Programming
colors library, WebDB: 3.1.2.3. Building shared components, Oracle Web Applications
column groups: 16.2. Column Groups with DBMS_REPCAT, Oracle Built-in Packages
adding columns: 16.2.3.1. The DBMS_REPCAT.ADD_GROUPED_COLUMN procedure, Oracle Built-in Packages
comments, creating or replacing: 16.2.3.3. The DBMS_REPCAT.COMMENT_ON_COLUMN_GROUP procedure, Oracle Built-in Packages
concepts: 16.2.1. About Column Groups, Oracle Built-in Packages
creating with columns: 16.2.2.3. The DBMS_REPCAT.MAKE_COLUMN_GROUP procedure, Oracle Built-in Packages
creating without columns: 16.2.2.1. The DBMS_REPCAT.DEFINE_COLUMN_GROUP procedure, Oracle Built-in Packages
dropping column groups: 16.2.2.2. The DBMS_REPCAT.DROP_COLUMN_GROUP procedure, Oracle Built-in Packages
dropping columns: 16.2.3.2. The DBMS_REPCAT.DROP_GROUPED_COLUMN procedure, Oracle Built-in Packages
columns
(see also records)
9.1.1. Different Types of Records, Oracle PL/SQL Programming
BFILE, initializing: 13.2.1. The BFILENAME function, Oracle PL/SQL Programming
abbreviations for: 3.2. Formatting SQL Statements, Oracle PL/SQL Programming
aliases for
3.2. Formatting SQL Statements, Oracle PL/SQL Programming
6.7. Column Aliases in Cursors, Oracle PL/SQL Programming
9.3.2. Setting the Record's Column Names, Oracle PL/SQL Programming
choosing for cursor-based record: 9.3.1. Choosing Columns for a Cursor Record, Oracle PL/SQL Programming
collections as: 19.2.1.1. Collection as a "column" in a conventional table, Oracle PL/SQL Programming
collections as datatypes for: 19.1. Types of Collections, Oracle PL/SQL Programming
datatype determination (example): 2.5.4.3. Constructing the SELECT, Oracle Built-in Packages
datatype values for: 2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure, Oracle Built-in Packages
defining
2.3.1. Processing Flow of Dynamic SQL, Oracle Built-in Packages
2.3.5. Defining Cursor Columns, Oracle Built-in Packages
describing: 2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure, Oracle Built-in Packages
names for: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming
naming procedure: 17.6. Column/Function Name Precedence, Oracle PL/SQL Programming
objects for: 18.1.2. Some Simple Examples, Oracle PL/SQL Programming
VALUE operator with: 18.4.2.3. VALUE, Oracle PL/SQL Programming
partial values of: 17.8.5. GROUP BY Partial Column Values, Oracle PL/SQL Programming
pseudocolumns: 9.1.2. ROWID Concepts, Oracle Built-in Packages
represented by variables: 4.7.7. Use %TYPE When a Variable Represents a Column, Oracle PL/SQL Programming
retrieving
2.3.1. Processing Flow of Dynamic SQL, Oracle Built-in Packages
2.3.8. Retrieving Values , Oracle Built-in Packages
retrieving descriptions of: 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages
retrieving number of in tables: 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages
sequential processing against value: 17.8.6. Sequential Processing Against a Column's Value, Oracle PL/SQL Programming
synchronization with: 4.5.1.1. Synchronization with database columns, Oracle PL/SQL Programming
where OIDS are stored: 18.4.2.1. Object identifiers (OIDs), Oracle PL/SQL Programming
columns, table: (see tables)
comma-delimited lists
creating: 10.1.2.20. The DBMS_UTILITY.TABLE_TO_COMMA procedure, Oracle Built-in Packages
parsing: 10.1.2.4. The DBMS_UTILITY.COMMA_TO_TABLE procedure, Oracle Built-in Packages
comment, HTML tag: 5.2.1. Structural Tags, Oracle Web Applications
comments
2.2. Using Effective Coding Style for Packages, Advanced Oracle PL/SQL Programming with Packages
5.13.5. Help generators, Advanced Oracle PL/SQL Programming with Packages
5.16.1. Analyzing PL/SQL string content, Advanced Oracle PL/SQL Programming with Packages
10.3.2.1. plsql_string procedure, Advanced Oracle PL/SQL Programming with Packages
17.4.3. Creating Help Text, Advanced Oracle PL/SQL Programming with Packages
2.5. Comments, Oracle PL/SQL Programming
associated with transactions: 6.1.1. The COMMIT Statement, Oracle PL/SQL Programming
describing parameters: 22.7.1. Document All Parameters and Their Functions, Oracle PL/SQL Programming
encrypted code and: 23.7.3. Impact of Encrypting Code, Oracle PL/SQL Programming
generating
16.2.5.1. Generating help text stubs, Advanced Oracle PL/SQL Programming with Packages
16.3.7. Generating Online Help Text Stubs, Advanced Oracle PL/SQL Programming with Packages
in PL/SQL: 6.2.1. Comments, Oracle Web Applications
retrieving: 17.5.3. Implementing Online Help, Advanced Oracle PL/SQL Programming with Packages
symbols for: 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
using effectively: 3.6. Using Comments Effectively, Oracle PL/SQL Programming
commit processing: 20.1. PLVcmt: Enhancing Commit Processing, Advanced Oracle PL/SQL Programming with Packages
incremental commits: 20.1.3. Performing Incremental Commits, Advanced Oracle PL/SQL Programming with Packages
toggling: 20.1.4. Controlling Commit Processing, Advanced Oracle PL/SQL Programming with Packages
commit_after procedure
5.7.4. Managing the commit counter, Advanced Oracle PL/SQL Programming with Packages
12.9.3. Clearing the Target, Advanced Oracle PL/SQL Programming with Packages
20.1.3.1. Setting the commit point, Advanced Oracle PL/SQL Programming with Packages
commitment: 4.2.3. Committing Data, Oracle Built-in Packages
DDL statement processing and: 10.3.1. Getting Started with DBMS_DDL, Oracle Built-in Packages
alerts and: 3.2.2.5. The DBMS_ALERT.SIGNAL procedure, Oracle Built-in Packages
deferred transactions and
17.2.4.5. The DBMS_DEFER_SYS.SET_DISABLED procedure, Oracle Built-in Packages
17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure, Oracle Built-in Packages
17.3.2.3. The DBMS_DEFER.COMMIT_WORK procedure, Oracle Built-in Packages
job scheduling and
13.2.5.1. The DBMS_JOB.SUBMIT procedure, Oracle Built-in Packages
13.2.7.3. The DBMS_JOB.RUN procedure, Oracle Built-in Packages
locks
allocating locks: 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure, Oracle Built-in Packages
named locks: 4.1.3.4. ALLOCATE_UNIQUE drawbacks, Oracle Built-in Packages
persistence: 4.1.2.2. The DBMS_LOCK.REQUEST function, Oracle Built-in Packages
commits
A.2.6. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!), Guide to Oracle8i Features
2.3. When to Use Autonomous Transactions, Guide to Oracle8i Features
committed_TF function: 4.1.4.1. The dblock package, Oracle Built-in Packages
committing function: 5.7.1. Controlling commit activity, Advanced Oracle PL/SQL Programming with Packages
communications protocols: 1.1. The Internet Grows Up, Oracle Web Applications
companion disk (see Companion Utilities Guide)
comparing
collections: 19.4.4. Comparing Collections, Oracle PL/SQL Programming
objects: 18.3.6. Comparing Objects, Oracle PL/SQL Programming
records: 9.1.6. Comparing Two Records, Oracle PL/SQL Programming
strings
4.2.3.2. The VARCHAR2 and VARCHAR datatypes, Oracle PL/SQL Programming
11.1.13. The SOUNDEX function, Oracle PL/SQL Programming
with NULL: 4.3. NULLs in PL/SQL, Oracle PL/SQL Programming
comparison methods: 18.3.1. About Object Types, Oracle PL/SQL Programming
compatibility
3.3. Supplying Backward Compatibility, Advanced Oracle PL/SQL Programming with Packages
3.11. Don't Forget Backward Compatibility, Advanced Oracle PL/SQL Programming with Packages
compatibility function: 10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure, Oracle Built-in Packages
compatible parameter, CREATE_QUEUE_TABLE procedure: 7.6.1. CREATE_QUEUE_TABLE and MIGRATE_QUEUE_TABLE: Setting Version Compatibility and Queue Migration, Guide to Oracle8i Features
compilation
automatic: 23.3.1. Interdependencies of Stored Objects, Oracle PL/SQL Programming
errors, viewing: 23.5.4. Viewing Compilation Errors in SQL*Plus, Oracle PL/SQL Programming
manual: 23.3.1. Interdependencies of Stored Objects, Oracle PL/SQL Programming
of modules: 4.5.2. Anchoring at Compile Time, Oracle PL/SQL Programming
compile procedure
5.9.4. Data Definition Language operations, Advanced Oracle PL/SQL Programming with Packages
19.4.1.7. Compiling source code with PLVdyn, Advanced Oracle PL/SQL Programming with Packages
compiler constructs: (see pragmas)
compiling: 15. PLVvu: Viewing Source Code and Compile Errors, Advanced Oracle PL/SQL Programming with Packages
code: 1.3.6. Performance Improvement, Advanced Oracle PL/SQL Programming with Packages
with PLVdyn: 19.4.1.7. Compiling source code with PLVdyn, Advanced Oracle PL/SQL Programming with Packages
errors: 5.29.4. Displaying compile errors, Advanced Oracle PL/SQL Programming with Packages
forced: 20.7.3. Forcing Compilation, Oracle PL/SQL Programming
package specifications: 1.7.3. Center All Development Around Packages, Oracle PL/SQL Programming
compiling and loading Java into Oracle: 9.3.3. Compiling and Loading into Oracle, Guide to Oracle8i Features
complete refresh: 1.3.8.2. EnterpriseSync Lite, Oracle Web Applications
compound symbols: (see symbols)
compressed data: (see message buffers, compressed data in)
concatenation
concatenation (||) operator
4.3.3. Function Results with NULL Arguments, Oracle PL/SQL Programming
11.1.3. The CONCAT function, Oracle PL/SQL Programming
SQL statement construction by: 2.3.4. Binding Values into Dynamic SQL, Oracle Built-in Packages
binding versus concatenation: 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
raw data
9.2.3.10. The UTL_RAW.COPIES function, Oracle Built-in Packages
9.2.3.8. The UTL_RAW.CONCAT function, Oracle Built-in Packages
string
4.3.3. Function Results with NULL Arguments, Oracle PL/SQL Programming
11.1.3. The CONCAT function, Oracle PL/SQL Programming
versus binding: 4.4.1. Binding Versus Concatenation, Guide to Oracle8i Features
concurrency, raw data and: 9.2. UTL_RAW: Manipulating Raw Data, Oracle Built-in Packages
conditional control structures: 5. Conditional and Sequential Control, Oracle PL/SQL Programming
formatting: 3.3. Formatting Control Structures, Oracle PL/SQL Programming
conditional logic
A.1.1. Conditional Logic, Advanced Oracle PL/SQL Programming with Packages
A.2.1. Conditional Logic, Advanced Oracle PL/SQL Programming with Packages
conditional loops: (see loops)
conditional statements, PL/SQL: 6.2.3. Conditionals, Oracle Web Applications
conditionals: 6.2.3. Conditionals, Oracle Web Applications
configuration file, HTTP listener: 3.2.3.4. Configuration file, Oracle Web Applications
configuring
PLVfk package: 19.6.2. Configuring the PLVfk Package, Advanced Oracle PL/SQL Programming with Packages
conflict resolution
16. Conflict Resolution, Oracle Built-in Packages
adding resolution types: 16.5.1.1. The DBMS_REPCAT.ADD_<conflicttype>_RESOLUTION, Oracle Built-in Packages
auditing: 16.6. Monitoring Conflict Resolution with DBMS_REPCAT, Oracle Built-in Packages
purging data: 16.6.1.3. The DBMS_REPCAT.PURGE_STATISTICS procedure, Oracle Built-in Packages
starting data collection: 16.6.1.1. The DBMS_REPCAT.REGISTER_STATISTICS procedure, Oracle Built-in Packages
stopping data collection: 16.6.1.2. The DBMS_REPCAT.CANCEL_STATISTICS procedure, Oracle Built-in Packages
comments on resolution types, creating or replacing: 16.5.1.3. The DBMS_REPCAT.COMMENT_ON_<conflicttype>_RESOLUTION procedure, Oracle Built-in Packages
data dictionary views: 16.1.4. Data Dictionary Views, Oracle Built-in Packages
dropping resolution types: 16.5.1.2. The DBMS_REPCAT.DROP_<conflicttype>_RESOLUTION procedure, Oracle Built-in Packages
methods: 16.5.1. About Resolution Methods, Oracle Built-in Packages
replication support and: 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure, Oracle Built-in Packages
replication triggers and: 14.1.2.2. The DBMS_SNAPSHOT.SET_I_AM_A_REFRESH procedure, Oracle Built-in Packages
connecting databases to web: 1.4.1. Connect the Database to the Web Using OAS or WebDB, Oracle Web Applications
connections, PL/SQL and: 2.4.7. Executing DDL in PL/SQL, Oracle Built-in Packages
consistency
dequeuing and: 5.4.2.5. Dequeue navigation, Oracle Built-in Packages
raw data and: 9.2. UTL_RAW: Manipulating Raw Data, Oracle Built-in Packages
consolidation of code: 2.9.2. Lava Lamp Code Consolidation, Advanced Oracle PL/SQL Programming with Packages
constants: (see literals; named constants; variables)
constrained datatypes
4.4.1. Constrained Declarations, Oracle PL/SQL Programming
4.6. Programmer-Defined Subtypes, Oracle PL/SQL Programming
4.6.3. Emulating Constrained Subtypes, Oracle PL/SQL Programming
constructor methods
18.2.2.1. PL/SQL usage , Oracle PL/SQL Programming
18.3.1. About Object Types, Oracle PL/SQL Programming
18.4.1.1. Constructors, Oracle PL/SQL Programming
constructors
initializing collections: 19.4.1.1. Initializing with a constructor, Oracle PL/SQL Programming
consumers
(see also multiple consumers; producers)
5.1.2. Enqueue Features, Oracle Built-in Packages
5.1.5. A Glossary of Terms, Oracle Built-in Packages
delaying dequeuing: 5.3.6. Message Properties Record Type, Oracle Built-in Packages
specifying: 5.3.8. Dequeue Options Record Type, Oracle Built-in Packages
content delivery model: 2.3. Content Delivery Model, Oracle Web Applications
HTTP Listener: 2.3.1. The HTTP Listener, Oracle Web Applications
PL/SQL gateways: 2.4. Database Integration, Oracle Web Applications
content management
1.2. Current Web Techniques Are Inadequate, Oracle Web Applications
1.2.1. Content Management, Oracle Web Applications
1.3.5. WebDB, Oracle Web Applications
content-driven web site management, WebDB: 3.1.3. Content-Driven Web Site Management, Oracle Web Applications
context switching
1.3.4. Bulk Binds and Collects (Chapter 5, Bulking Up with PL/SQL 8.1), Guide to Oracle8i Features
5.1. Context-Switching Problem Scenarios, Guide to Oracle8i Features
control structures, iterative: (see loops)
conventions, naming: 4.7.1. Establish Clear Variable Naming Conventions , Oracle PL/SQL Programming
conversions
and format models: 14.1. Conversion Formats, Oracle PL/SQL Programming
functions for: 14. Conversion Functions, Oracle PL/SQL Programming
GET_LINE and: 6.2.3.1. The UTL_FILE.GET_LINE procedure, Oracle Built-in Packages
implicit: 14. Conversion Functions, Oracle PL/SQL Programming
raw data and
9.2.2.1. Conversion and coercion, Oracle Built-in Packages
9.2.3.5. The UTL_RAW.CAST_TO_RAW function, Oracle Built-in Packages
9.2.3.9. The UTL_RAW.CONVERT function, Oracle Built-in Packages
convert_type procedure
5.20.8. Miscellaneous PLVobj programs, Advanced Oracle PL/SQL Programming with Packages
11.3.2. Converting the Program Name, Advanced Oracle PL/SQL Programming with Packages
converting
PL/SQL table to database table: 21.1.4.3. Transferring a PL/SQL table log to a database table, Advanced Oracle PL/SQL Programming with Packages
between datatypes: 4.2.8. Conversion Between Datatypes, Oracle PL/SQL Programming
case: (see capitalization)
datatypes
external procedures and: 21.4.1. Datatype Conversion, Oracle PL/SQL Programming
performance and: 25.4.7. Avoid Type Conversions When Possible, Oracle PL/SQL Programming
explicitly versus implicitly: 4.2.8.1. Explicit data conversions, Oracle PL/SQL Programming
program name: 11.3.2. Converting the Program Name, Advanced Oracle PL/SQL Programming with Packages
scripts into PL/SQL: 4.4.3. Converting Scripts to PL/SQL Programs, Advanced Oracle PL/SQL Programming with Packages
to row numbers: 10.5.1. Automatic Conversion of Row Number Expressions, Oracle PL/SQL Programming
to/from hexadecimal: 14.2.3. The HEXTORAW function, Oracle PL/SQL Programming
triggers to procedures: 25.3.7. Keep Database Triggers Small, Oracle PL/SQL Programming
variables to named constants: 4.7.5. Convert Variables into Named Constants , Oracle PL/SQL Programming
convobj procedure
5.20.8. Miscellaneous PLVobj programs, Advanced Oracle PL/SQL Programming with Packages
11.3.2. Converting the Program Name, Advanced Oracle PL/SQL Programming with Packages
cookies, OWA_COOKIE package: 7.3.1. OWA_COOKIE: Storing Cookies, Oracle Web Applications
copying
file contents: 13.7. Copying File Contents, Advanced Oracle PL/SQL Programming with Packages
files: 5.11.11. Copying a file, Advanced Oracle PL/SQL Programming with Packages
from source to target repository: 5.15.9. Miscellaneous PLVio programs, Advanced Oracle PL/SQL Programming with Packages
object names into table: 11.6. Populating a PL/SQL Table with Object Names, Advanced Oracle PL/SQL Programming with Packages
source to target repository: 12.7.2. Batch Transfer of Source to Target, Advanced Oracle PL/SQL Programming with Packages
copyto procedure
2.5.5. Indirect Referencing in PL/SQL, Oracle Built-in Packages
2.5.5.3. Copying a value to a packaged variable, Oracle Built-in Packages
cor procedure: 19.4.1.7. Compiling source code with PLVdyn, Advanced Oracle PL/SQL Programming with Packages
correlated subqueries: 17.8.3. Replacing Correlated Subqueries, Oracle PL/SQL Programming
correlation identifiers: 5.3.6. Message Properties Record Type, Oracle Built-in Packages
dequeuing and: 5.3.8. Dequeue Options Record Type, Oracle Built-in Packages
example: 5.7.5. Searching by Correlation Identifier, Oracle Built-in Packages
wildcarding: 5.7.5.1. Wildcarded correlation identifiers, Oracle Built-in Packages
correlation variables: 18.4.2.2. REFs, Oracle PL/SQL Programming
countBy program, ndsutil.pkg file: 4.7. NDS Utility Package, Guide to Oracle8i Features
counted loops: (see numeric FOR loops)
counter, PLVcmt: (see PLVcmt package)
counter, commit: 5.7.4. Managing the commit counter, Advanced Oracle PL/SQL Programming with Packages
counting substring occurrences: 11.2.4. Counting Substring Occurrences in Strings, Oracle PL/SQL Programming
cover packages: 1.6.4. Working with Large Packages, Advanced Oracle PL/SQL Programming with Packages
covering encapsulation: 1.3.5. Encapsulating Access to the Built-in Packages, Oracle Built-in Packages
create-or-replace syntax: 16.3.9. Including CREATE OR REPLACE, Advanced Oracle PL/SQL Programming with Packages
create_file procedure: 6.2.7.2. Creating a file, Oracle Built-in Packages
create_msg_form procedure, FORUM package
8.3.6. The FORUM Package, Oracle Web Applications
8.3.6.2. Body, Oracle Web Applications
create_priority_queue procedure: 5.7.1. Improving AQ Ease of Use, Oracle Built-in Packages
create_queue procedure: 5.7.1. Improving AQ Ease of Use, Oracle Built-in Packages
create_user_form, FORUM_USERS package
8.3.5. The FORUM_USERS Package, Oracle Web Applications
8.3.5.2. Body, Oracle Web Applications
creating
files: 13.3. Creating and Checking Existence of Files, Advanced Oracle PL/SQL Programming with Packages
lists: 5.18.2. Creating and destroying lists, Advanced Oracle PL/SQL Programming with Packages
messages: 9.2. Storing Message Text, Advanced Oracle PL/SQL Programming with Packages
stacks: 5.24.2. Creating and destroying stacks, Advanced Oracle PL/SQL Programming with Packages
creativity: 4.1.1. The Benefits of PL/Vision, Advanced Oracle PL/SQL Programming with Packages
crefile.sp : 6.2.7.2. Creating a file, Oracle Built-in Packages
creind.sp : 2.1. Examples of Dynamic SQL, Oracle Built-in Packages
cretemplob.sql file: 7.5.2.4. Example, Guide to Oracle8i Features
cur%FOUND cursor attribute: 5.4. Using Cursor Attributes, Guide to Oracle8i Features
cur%ISOPEN cursor attribute: 5.4. Using Cursor Attributes, Guide to Oracle8i Features
cur%NOTFOUND cursor attribute: 5.4. Using Cursor Attributes, Guide to Oracle8i Features
cur%ROWCOUNT cursor attribute: 5.4. Using Cursor Attributes, Guide to Oracle8i Features
curdecl procedure
5.13.10. Miscellaneous code generators, Advanced Oracle PL/SQL Programming with Packages
16.2.6. Generating a Cursor Declaration, Advanced Oracle PL/SQL Programming with Packages
curfail procedure: 5.27.6. Calibration and timing scripts, Advanced Oracle PL/SQL Programming with Packages
currency format (NLS), setting: 11.1.2.3. The DBMS_SESSION.SET_NLS procedure, Oracle Built-in Packages
current transaction, registering: 7.2.3. The DBMS_APPLICATION_INFO.SET_ACTION procedure, Oracle Built-in Packages
current_choice function: 5.7.8.2. Overriding with a recipient list, Oracle Built-in Packages
current_forum_list procedure, FORUM package
8.3.6. The FORUM Package, Oracle Web Applications
8.3.6.2. Body, Oracle Web Applications
current_name function: 12.1.3.1. The segspace package, Oracle Built-in Packages
current_row function: 7.3.9. Tracking Long-Running Processes, Oracle Built-in Packages
current_schema function: 12.1.3.1. The segspace package, Oracle Built-in Packages
current_type function: 12.1.3.1. The segspace package, Oracle Built-in Packages
currmod function
5.28.6. Tracing PL/SQL code execution, Advanced Oracle PL/SQL Programming with Packages
21.2.4.3. Current module, Advanced Oracle PL/SQL Programming with Packages
currname function
5.20.4. Accessing the current object, Advanced Oracle PL/SQL Programming with Packages
11.3.1. Setting Individual Elements of Current Object, Advanced Oracle PL/SQL Programming with Packages
currschema function
5.20.4. Accessing the current object, Advanced Oracle PL/SQL Programming with Packages
11.3.1. Setting Individual Elements of Current Object, Advanced Oracle PL/SQL Programming with Packages
currtype function
5.20.4. Accessing the current object, Advanced Oracle PL/SQL Programming with Packages
11.3.1. Setting Individual Elements of Current Object, Advanced Oracle PL/SQL Programming with Packages
cursor FOR loops: 7.4. The Cursor FOR Loop, Oracle PL/SQL Programming
formatting: 3.3.2. Formatting Loops, Oracle PL/SQL Programming
premature termination of: 7.7.2.1. Premature FOR loop termination, Oracle PL/SQL Programming
records in: 7.4.2. The Cursor FOR Loop Record, Oracle PL/SQL Programming
scope of: 7.6.2.1. Scope in FOR loops, Oracle PL/SQL Programming
cursor attributes: 5.4. Using Cursor Attributes, Guide to Oracle8i Features
cursor variables
aliases for: 6.12.6.3. Cursor variable aliases, Oracle PL/SQL Programming
as arguments: 6.12.7. Passing Cursor Variables as Arguments, Oracle PL/SQL Programming
attributes of: 6.12.2. Similarities to Static Cursors, Oracle PL/SQL Programming
dynamic SQL and: 2.4.1. Some Restrictions, Oracle Built-in Packages
scope of: 6.12.6.4. Scope of cursor object, Oracle PL/SQL Programming
cursor_variable, OPEN FOR statement: 4.2.2. The OPEN FOR Statement, Guide to Oracle8i Features
cursors
A.1.4. Cursors, Advanced Oracle PL/SQL Programming with Packages
A.2.4. Cursors, Advanced Oracle PL/SQL Programming with Packages
1.3.4. Object Persistence, Advanced Oracle PL/SQL Programming with Packages
1.4.1. The Package Specification, Advanced Oracle PL/SQL Programming with Packages
6.2. Cursors in PL/SQL, Oracle PL/SQL Programming
6.2.5. Cursors, Oracle Web Applications
FOR loop
11.7. A Programmatic Cursor FOR Loop, Advanced Oracle PL/SQL Programming with Packages
16.2.8. Generating a Cursor FOR Loop, Advanced Oracle PL/SQL Programming with Packages
1.6.4. The cursor FOR loop, Oracle PL/SQL Programming
1.7.1. Write as Little Code as Possible, Oracle PL/SQL Programming
LOBs and: 8.2.1.1. Internal and external LOBs, Oracle Built-in Packages
PLVobj package (obj_cur)
5.20.5. Interfacing with the PLVobj cursor, Advanced Oracle PL/SQL Programming with Packages
11.2.1. Cursor Into ALL_OBJECTS, Advanced Oracle PL/SQL Programming with Packages
11.4.1. Opening and Closing the PLVobj Cursor, Advanced Oracle PL/SQL Programming with Packages
RETURN statement: 6.4.4. The Cursor RETURN Clause, Oracle PL/SQL Programming
SELECT FOR UPDATE statement: 6.11. SELECT FOR UPDATE in Cursors, Oracle PL/SQL Programming
attributes of: 6.9. Cursor Attributes, Oracle PL/SQL Programming
%FOUND: 6.9.1. The %FOUND Attribute, Oracle PL/SQL Programming
%ISOPEN
6.5. Opening Cursors, Oracle PL/SQL Programming
6.9.4. The %ISOPEN Attribute, Oracle PL/SQL Programming
%NOTFOUND
6.6.2. Fetching Past the Last Row, Oracle PL/SQL Programming
6.9.2. The %NOTFOUND Attribute, Oracle PL/SQL Programming
%ROWCOUNT: 6.9.3. The %ROWCOUNT Attribute, Oracle PL/SQL Programming
for cursor variables: 6.12.2. Similarities to Static Cursors, Oracle PL/SQL Programming
binding objects to: 11.5. Binding Objects to a Dynamic Cursor, Advanced Oracle PL/SQL Programming with Packages
checking status
2.3.10. Checking Cursor Status, Oracle Built-in Packages
2.3.2.2. The DBMS_SQL.IS_OPEN function, Oracle Built-in Packages
closing
2.3.1. Processing Flow of Dynamic SQL, Oracle Built-in Packages
2.3.9. Closing the Cursor , Oracle Built-in Packages
2.3.9.1. The DBMS_SQL.CLOSE_CURSOR procedure, Oracle Built-in Packages
2.4.4. Minimizing Memory for Cursors, Oracle Built-in Packages
6.8. Closing Cursors, Oracle PL/SQL Programming
cached cursors: 11.1.4.4. The DBMS_SESSION.SET_CLOSE_CACHED_OPEN_CURSORS procedure, Oracle Built-in Packages
column aliases in: 6.7. Column Aliases in Cursors, Oracle PL/SQL Programming
corresponding to records: 9.1.4. Guidelines for Using Records, Oracle PL/SQL Programming
cursor variables
1.4.5.2. Cursor variables, Oracle PL/SQL Programming
6.2.1. Types of Cursors, Oracle PL/SQL Programming
6.12. Cursor Variables, Oracle PL/SQL Programming
restrictions on: 6.12.8. Cursor Variable Restrictions, Oracle PL/SQL Programming
database access based on: 1.4.3.8. Cursor-based access to the database, Oracle PL/SQL Programming
declaring: 6.4. Declaring Cursors, Oracle PL/SQL Programming
in packages: 16.3.2. Declaring Package Cursors, Oracle PL/SQL Programming
defining columns: 2.3.5. Defining Cursor Columns, Oracle Built-in Packages
defining structure of (example): 2.5.4.5. Defining the cursor structure, Oracle Built-in Packages
examples of using: 6.13. Working with Cursors , Oracle PL/SQL Programming
executing associated SQL statement: 2.3.6.1. The DBMS_SQL.EXECUTE function, Oracle Built-in Packages
explicit
1.7.4. Standardize Your PL/SQL Development Environment, Oracle PL/SQL Programming
6.2.1. Types of Cursors, Oracle PL/SQL Programming
6.3.3. Explicit Cursors, Oracle PL/SQL Programming
FETCH INTO from: 9.5.3. FETCH INTO from an Explicit Cursor, Oracle PL/SQL Programming
fetching from
1.7.2. Synchronize Program and Data Structures, Oracle PL/SQL Programming
6.6. Fetching from Cursors, Oracle PL/SQL Programming
generating declaration: 16.2.6. Generating a Cursor Declaration, Advanced Oracle PL/SQL Programming with Packages
group functions in: 6.13.1.1. Inefficiency of group functions in cursors, Oracle PL/SQL Programming
identifier precedence: 6.4.3. Identifier Precedence in a Cursor, Oracle PL/SQL Programming
implicit
1.7.4. Standardize Your PL/SQL Development Environment, Oracle PL/SQL Programming
6.2.1. Types of Cursors, Oracle PL/SQL Programming
6.3.1. Implicit Cursors, Oracle PL/SQL Programming
6.9. Cursor Attributes, Oracle PL/SQL Programming
6.9.5. Implicit SQL Cursor Attributes, Oracle PL/SQL Programming
SELECT INTO from: 9.5.2. SELECT INTO from an Implicit Cursor, Oracle PL/SQL Programming
naming: 6.4.1. The Cursor Name, Oracle PL/SQL Programming
obtaining structure of (example): 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages
opening
2.3.1. Processing Flow of Dynamic SQL, Oracle Built-in Packages
2.3.2. Opening the Cursor, Oracle Built-in Packages
2.3.2.1. The DBMS_SQL.OPEN_CURSOR function, Oracle Built-in Packages
6.2.2. Cursor Operations, Oracle PL/SQL Programming
6.5. Opening Cursors, Oracle PL/SQL Programming
6.10.2. Opening Cursors with Parameters, Oracle PL/SQL Programming
parameters of: 6.10. Cursor Parameters, Oracle PL/SQL Programming
pinning into shared pool: 12.2.4.2. Pinning cursors into the shared pool, Oracle Built-in Packages
records based on: 9.3. Cursor-Based Records, Oracle PL/SQL Programming
reusing
2.3.2.1. The DBMS_SQL.OPEN_CURSOR function, Oracle Built-in Packages
2.3.4. Binding Values into Dynamic SQL, Oracle Built-in Packages
2.4.4. Minimizing Memory for Cursors, Oracle Built-in Packages
scope of: 15.3.5.4. Cursor scope, Oracle PL/SQL Programming
specifying in packages: 16.3. The Package Specification, Oracle PL/SQL Programming
static: 6.2.1. Types of Cursors, Oracle PL/SQL Programming
storing in packages: 5.3. Bulk Querying with the BULK COLLECT Clause, Guide to Oracle8i Features
variables in: 6.4.2. PL/SQL Variables in a Cursor, Oracle PL/SQL Programming
cursucc procedure: 5.27.6. Calibration and timing scripts, Advanced Oracle PL/SQL Programming with Packages
custom Java classes, building: 9.3.2. Building a Custom Java Class, Guide to Oracle8i Features
customizing
parsing delimiter: 10.1.2. Customizing the Delimiter Set, Advanced Oracle PL/SQL Programming with Packages
customizing programs for users: 2.8.1.2. Fitting the program to the user , Advanced Oracle PL/SQL Programming with Packages

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 | Y | Z

Copyright © 2000 O'Reilly & Associates, Inc. All rights reserved.