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: D

"do nothing" statement: (see NULL statements)

DAD: (see Database Access Descriptor)

DATABASE_NAME attribute, database-level event

6.2. Database-Level Event Triggers, Guide to Oracle8i Features
6.3. Schema-Level Event Triggers, Guide to Oracle8i Features

DATA_BLOCK_ADDRESS_BLOCK function

10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.6. The DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK function, Oracle Built-in Packages

DATA_BLOCK_ADDRESS_FILE function

10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.7. The DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE function, Oracle Built-in Packages

DATE datatype: 12. Date Functions, Oracle PL/SQL Programming

DATETYPE datatype: 7.4.1.3. Representing dates, Oracle Web Applications

DATE_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages

DB2 data source: 4.2.3.1. The CHAR datatype, Oracle PL/SQL Programming

DBA_2PC_PENDING view

4.2.2. Advising Oracle About In-Doubt Transactions, Oracle Built-in Packages
4.2.3.2. The DBMS_TRANSACTION.COMMIT_COMMENT procedure, Oracle Built-in Packages
4.2.3.3. The DBMS_TRANSACTION.COMMIT_FORCE procedure, Oracle Built-in Packages
4.2.4.2. The DBMS_TRANSACTION.ROLLBACK_FORCE procedure, Oracle Built-in Packages
4.2.6.1. The DBMS_TRANSACTION.PURGE_MIXED procedure, Oracle Built-in Packages
4.2.6.2. The DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure, Oracle Built-in Packages

DBA_CONTEXT data dictionary view: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features

DBA_ERRORS data dictionary view: 9.6.2. Examining Loaded Java Elements, Guide to Oracle8i Features

DBA_JOBS view

5.6.2.3. The DBA_JOBS view, Oracle Built-in Packages
13.3.2. Viewing Job Information in the Data Dictionary, Oracle Built-in Packages

DBA_JOBS_RUNNING view: 13.3.2. Viewing Job Information in the Data Dictionary, Oracle Built-in Packages

DBA_KEEPSIZES view: 12.2.4.3. The DBA_KEEPSIZES view, Oracle Built-in Packages

DBA_OBJECTS data dictionary view: 9.6.2. Examining Loaded Java Elements, Guide to Oracle8i Features

DBA_POLICIES data dictionary view: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features

DBA_QUEUES view

5.1.8. Data Dictionary Views, Oracle Built-in Packages
5.6.2.2. The DBA_QUEUES view, Oracle Built-in Packages

DBA_QUEUE_TABLES view

5.1.8. Data Dictionary Views, Oracle Built-in Packages
5.6.2.1. The DBA_QUEUE_TABLES view, Oracle Built-in Packages

DBA_REGISTERED_SNAPSHOTS view: 14.1.6. Registering Snapshots, Oracle Built-in Packages

DBA_REPCOLUMN_GROUP view: 16.1.4. Data Dictionary Views, Oracle Built-in Packages

DBA_REPCONFLICT view: 16.1.4. Data Dictionary Views, Oracle Built-in Packages

DBA_REPGROUPED_COLUMN view: 16.1.4. Data Dictionary Views, Oracle Built-in Packages

DBA_REPPARAMETER_COLUMN view: 16.1.4. Data Dictionary Views, Oracle Built-in Packages

DBA_REPPRIORITY view: 16.1.4. Data Dictionary Views, Oracle Built-in Packages

DBA_REPPRIORITY_GROUP view: 16.1.4. Data Dictionary Views, Oracle Built-in Packages

DBA_REPRESOLUTION view: 16.1.4. Data Dictionary Views, Oracle Built-in Packages

DBA_REPRESOLUTION_METHOD view: 16.1.4. Data Dictionary Views, Oracle Built-in Packages

DBA_REPRESOLUTION_STATISTICS view: 16.1.4. Data Dictionary Views, Oracle Built-in Packages

DBA_REPRESOL_STATS_CONTROL view: 16.1.4. Data Dictionary Views, Oracle Built-in Packages

DBA_SEGMENTS data dictionary view: 7.5.2.5. Managing temporary LOBs, Guide to Oracle8i Features

DBDOM package: 9.6. PLSXML Utilities and Demos, Oracle Web Applications

DBMS_ TRANSACTION package: 1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages

DBMS_ALERT package

(see also specific program names)
1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
3.2. DBMS_ALERT: Broadcasting Alerts to Users, Oracle Built-in Packages
3.2.1.1. DBMS_ALERT programs, Oracle Built-in Packages
Oracle Parallel Server and: 3.2.2.4. The DBMS_ALERT.SET_DEFAULTS procedure, Oracle Built-in Packages
creating: 3.2.1. Getting Started with DBMS_ALERT, Oracle Built-in Packages
examples: 3.2.3. DBMS_ALERT Examples, Oracle Built-in Packages
exceptions: 3.2.1.1. DBMS_ALERT programs, Oracle Built-in Packages
multiple consumers and: 5.7.8. Working with Multiple Consumers, Oracle Built-in Packages
privileges: 3.2.1. Getting Started with DBMS_ALERT, Oracle Built-in Packages
programs contained in: 3.2.1.1. DBMS_ALERT programs, Oracle Built-in Packages
transactional behavior: 3.2.3. DBMS_ALERT Examples, Oracle Built-in Packages

DBMS_APPLICATION_INFO package

(see also specific program names)

1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages

7. Defining an Application Profile, Oracle Built-in Packages

7.1.1. DBMS_APPLICATION_INFO Programs , Oracle Built-in Packages

V$ elements used: 7.1.2. The V$ Virtual Tables, Oracle Built-in Packages

creating: 7.1. Getting Started with DBMS_APPLICATION_INFO , Oracle Built-in Packages

distinguishing users with: 7.3.8. Session Monitoring and Three-Tier Architectures, Oracle Built-in Packages

encapsulating: 7.3.6. Covering DBMS_APPLICATION_INFO, Oracle Built-in Packages

examples of use: 7.3. DBMS_APPLICATION_INFO Examples , Oracle Built-in Packages

exceptions: 7.1.1. DBMS_APPLICATION_INFO Programs , Oracle Built-in Packages

performance analysis with

7. Defining an Application Profile, Oracle Built-in Packages
7.3. DBMS_APPLICATION_INFO Examples , Oracle Built-in Packages
7.3.7. Monitoring Application SQL Resource Consumption, Oracle Built-in Packages
7.3.8. Session Monitoring and Three-Tier Architectures, Oracle Built-in Packages

privileges: 7.1. Getting Started with DBMS_APPLICATION_INFO , Oracle Built-in Packages

programs contained in: 7.1.1. DBMS_APPLICATION_INFO Programs , Oracle Built-in Packages

DBMS_AQ package

(see also specific program names)

1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages

5. Oracle Advanced Queuing, Oracle Built-in Packages

5.4. DBMS_AQ: Interfacing to Oracle AQ (Oracle8 only), Oracle Built-in Packages

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i), Guide to Oracle8i Features

7.6. New DBMS_AQ and DBMS_AQADM Features, Guide to Oracle8i Features

C.3. Oracle AQ, the Advanced Queueing Facility, Oracle PL/SQL Programming

creating: 5.2.1. Installing the Oracle AQ Facility, Oracle Built-in Packages

exceptions

5.3.9. Oracle AQ Exceptions, Oracle Built-in Packages
5.4.2.6. Dequeuing with message grouping, Oracle Built-in Packages

privileges: 5.2.1. Installing the Oracle AQ Facility, Oracle Built-in Packages

programs contained in: 5.4. DBMS_AQ: Interfacing to Oracle AQ (Oracle8 only), Oracle Built-in Packages

roles: 5.4. DBMS_AQ: Interfacing to Oracle AQ (Oracle8 only), Oracle Built-in Packages

DBMS_AQADM package

(see also specific program names)

1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages

5. Oracle Advanced Queuing, Oracle Built-in Packages

5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages

7.6. New DBMS_AQ and DBMS_AQADM Features, Guide to Oracle8i Features

C.3.2. DBMS_AQADM (PL/SQL 8 Only), Oracle PL/SQL Programming

creating: 5.2.1. Installing the Oracle AQ Facility, Oracle Built-in Packages

exceptions

5.3.9. Oracle AQ Exceptions, Oracle Built-in Packages
5.5.3.1. The DBMS_AQADM.ADD_SUBSCRIBER procedure, Oracle Built-in Packages

privileges: 5.2.1. Installing the Oracle AQ Facility, Oracle Built-in Packages

programs contained in: 5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages

roles: 5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages

subscribers and: 5.5.3. Managing Queue Subscribers, Oracle Built-in Packages

DBMS_CRYPTO_TOOLKIT package: 10.4. DBMS_RANDOM: Generating Random Numbers (Oracle8 Only), Oracle Built-in Packages

DBMS_DDL package

(see also specific program names)
1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
10.3. DBMS_DDL: Compiling and Analyzing Objects, Oracle Built-in Packages
10.3.1.1. DBMS_DDL programs, Oracle Built-in Packages
C.4. DBMS_DDL, Oracle PL/SQL Programming
commitment and: 10.3.1. Getting Started with DBMS_DDL, Oracle Built-in Packages
creating: 10.3.1. Getting Started with DBMS_DDL, Oracle Built-in Packages
exceptions: 10.3.1.1. DBMS_DDL programs, Oracle Built-in Packages
privileges: 10.3.1. Getting Started with DBMS_DDL, Oracle Built-in Packages
programs contained in: 10.3.1.1. DBMS_DDL programs, Oracle Built-in Packages

DBMS_DEFER package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
17.3. DBMS_DEFER: Building Deferred Calls, Oracle Built-in Packages
17.3.1.1. DBMS_DEFER programs, Oracle Built-in Packages
creating: 17.3.1. Getting Started with DBMS_DEFER, Oracle Built-in Packages
exceptions: 17.3.1.2. DBMS_DEFER exceptions, Oracle Built-in Packages
privileges: 17.3. DBMS_DEFER: Building Deferred Calls, Oracle Built-in Packages
programs contained in: 17.3.1.1. DBMS_DEFER programs, Oracle Built-in Packages

DBMS_DEFER_QUERY package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
17.4. DBMS_DEFER_QUERY: Performing Diagnostics and Maintenance, Oracle Built-in Packages
17.4.1.1. DBMS_DEFER_QUERY programs, Oracle Built-in Packages
creating: 17.4.1. Getting Started with DBMS_DEFER_QUERY, Oracle Built-in Packages
exceptions: 17.4.1.1. DBMS_DEFER_QUERY programs, Oracle Built-in Packages
privileges: 17.4.1. Getting Started with DBMS_DEFER_QUERY, Oracle Built-in Packages
programs contained in: 17.4.1.1. DBMS_DEFER_QUERY programs, Oracle Built-in Packages

DBMS_DEFER_SYS package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
17.2. DBMS_DEFER_SYS: Managing Deferred Transactions, Oracle Built-in Packages
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
creating: 17.2.1. Getting Started with DBMS_DEFER_SYS, Oracle Built-in Packages
exceptions: 17.2.1.2. DBMS_DEFER_SYS exceptions, Oracle Built-in Packages
privileges: 17.2.1. Getting Started with DBMS_DEFER_SYS, Oracle Built-in Packages
programs contained in: 17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages

DBMS_DESCRIBE package

(see also specific program names)

1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages

10.2. DBMS_DESCRIBE: Describing PL/SQL Program Headers, Oracle Built-in Packages

10.2.1.1. DBMS_DESCRIBE program, Oracle Built-in Packages

DESCRIBE_PROCEDURE procedure: 17.2. Current Sources of Information, Advanced Oracle PL/SQL Programming with Packages

creating: 10.2.1. Getting Started with DBMS_DESCRIBE, Oracle Built-in Packages

example

10.2.3. DBMS_DESCRIBE Example, Oracle Built-in Packages
10.2.2. Explaining DBMS_DESCRIBE Results, Oracle Built-in Packages

exceptions: 10.2.1.4. Exceptions, Oracle Built-in Packages

level, meaning of: 10.2.2.2. The DESCRIBE level, Oracle Built-in Packages

overloading: 10.2.2.3. How overloading is handled, Oracle Built-in Packages

pinning in SGA shared pool: 25.2.2.1. Candidates for pinning in the shared pool, Oracle PL/SQL Programming

privileges: 10.2.1. Getting Started with DBMS_DESCRIBE, Oracle Built-in Packages

program name syntax: 10.2.2.1. Specifying a program name, Oracle Built-in Packages

programs contained in: 10.2.1.1. DBMS_DESCRIBE program, Oracle Built-in Packages

programs within packages and: 10.2.3.2. Using psdesc.args as a quality assurance tool, Oracle Built-in Packages

quality assurance using psdesc package: 10.2.3.2. Using psdesc.args as a quality assurance tool, Oracle Built-in Packages

DBMS_IJOB package: 13.3.3. DBMS_IJOB: Managing Other Users' Jobs , Oracle Built-in Packages

DBMS_INDEXING package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_JAVA package

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i), Guide to Oracle8i Features
7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features
9.1. Oracle8i and Java, Guide to Oracle8i Features
9.7. Using DBMS_JAVA and DBMS_JAVA_TEST, Guide to Oracle8i Features

DBMS_JAVA_TEST package

7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features
9.1. Oracle8i and Java, Guide to Oracle8i Features
9.7. Using DBMS_JAVA and DBMS_JAVA_TEST, Guide to Oracle8i Features
9.7.5. Using DBMS_JAVA_TEST , Guide to Oracle8i Features

DBMS_JOB package

(see also specific program names)
1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
13. Job Scheduling in the Database, Oracle Built-in Packages
13.1.1. DBMS_JOB Programs, Oracle Built-in Packages
C.5. DBMS_ JOB, Oracle PL/SQL Programming
1.4.5.3. Job scheduling with DBMS_ JOB, Oracle PL/SQL Programming
analyzing table space: 13.4.1. Tracking Space in Tablespaces, Oracle Built-in Packages
creating: 13.1. Getting Started with DBMS_ JOB, Oracle Built-in Packages
exceptions: 13.1.1. DBMS_JOB Programs, Oracle Built-in Packages
privileges: 13.1. Getting Started with DBMS_ JOB, Oracle Built-in Packages
programs contained in: 13.1.1. DBMS_JOB Programs, Oracle Built-in Packages

DBMS_LOB package

(see also specific program names)

1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages

8. Managing Large Objects , Oracle Built-in Packages

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i), Guide to Oracle8i Features

C.6. DBMS_LOB (PL/SQL8 Only), Oracle PL/SQL Programming

creating: 8.1. Getting Started with DBMS_LOB, Oracle Built-in Packages

examples, introduction to: 8.1.4. About the Examples, Oracle Built-in Packages

exceptions: 8.1.2. DBMS_LOB Exceptions, Oracle Built-in Packages

handling of: 8.1.4. About the Examples, Oracle Built-in Packages

privileges: 8.1. Getting Started with DBMS_LOB, Oracle Built-in Packages

programs contained in: 8.1.1. DBMS_LOB Programs, Oracle Built-in Packages

DBMS_LOCK package

(see also specific program names)
1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
4.1. DBMS_LOCK: Creating and Managing Resource Locks, Oracle Built-in Packages
4.1.1.1. DBMS_LOCK programs, Oracle Built-in Packages
C.7. DBMS_LOCK, Oracle PL/SQL Programming
alert signaling and: 3.2.2.5. The DBMS_ALERT.SIGNAL procedure, Oracle Built-in Packages
creating: 4.1.1. Getting Started with DBMS_LOCK, Oracle Built-in Packages
examples: 4.1.4. DBMS_LOCK Examples, Oracle Built-in Packages
exceptions: 4.1.1.1. DBMS_LOCK programs, Oracle Built-in Packages
privileges: 4.1.1. Getting Started with DBMS_LOCK, Oracle Built-in Packages
programs contained in: 4.1.1.1. DBMS_LOCK programs, Oracle Built-in Packages
serializing locks: 4.1. DBMS_LOCK: Creating and Managing Resource Locks, Oracle Built-in Packages
tips on using: 4.1.3. Tips on Using DBMS_LOCK, Oracle Built-in Packages

DBMS_LOG_MNR package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_LOG_MNR_D package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_MAIL package

1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
C.8. DBMS_MAIL, Oracle PL/SQL Programming

DBMS_OFFLINE_OG package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
15.4. DBMS_OFFLINE_OG: Performing Site Instantiation, Oracle Built-in Packages
15.4.1. Getting Started with DBMS_OFFLINE_OG, Oracle Built-in Packages
creating: 15.4.1. Getting Started with DBMS_OFFLINE_OG, Oracle Built-in Packages
exceptions: (see specific program names)
privileges: 15.4.1. Getting Started with DBMS_OFFLINE_OG, Oracle Built-in Packages
programs contained in: 15.4.1. Getting Started with DBMS_OFFLINE_OG, Oracle Built-in Packages

DBMS_OFFLINE_SNAPSHOT package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
14.3. DBMS_OFFLINE_SNAPSHOT: Performing Offline Snapshot Instantiation, Oracle Built-in Packages
14.3.1.1. DBMS_OFFLINE_SNAPSHOT programs, Oracle Built-in Packages
creating: 14.3.1. Getting Started with DBMS_OFFLINE_SNAPSHOT, Oracle Built-in Packages
exceptions: 14.3.1.2. DBMS_OFFLINE_SNAPSHOT exceptions, Oracle Built-in Packages
privileges: 14.3.1. Getting Started with DBMS_OFFLINE_SNAPSHOT, Oracle Built-in Packages
programs contained in: 14.3.1.1. DBMS_OFFLINE_SNAPSHOT programs, Oracle Built-in Packages

DBMS_OUTPUT package

(see also specific program names)

1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages

7.1.2. Displaying Dates, Advanced Oracle PL/SQL Programming with Packages

22.3.2.2. Drawbacks of the usual handlers, Advanced Oracle PL/SQL Programming with Packages

1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages

6.1. DBMS_OUTPUT: Displaying Output, Oracle Built-in Packages

6.1.1.1. DBMS_OUTPUT programs, Oracle Built-in Packages

2.4.1. Using Autonomous Transactions from Within SQL, Guide to Oracle8i Features

7.6.4.2. LISTEN: Listening for messages, Guide to Oracle8i Features

C.9. DBMS_OUTPUT, Oracle PL/SQL Programming

10.9.3. Displaying a PL/SQL Table, Oracle PL/SQL Programming

26.5. Quick-and-Dirty Tracing, Oracle PL/SQL Programming

ENABLE procedure: 7.4. Controlling Output from p, Advanced Oracle PL/SQL Programming with Packages

PUT_LINE function: 7. p: A Powerful Substitute for DBMS_OUTPUT, Advanced Oracle PL/SQL Programming with Packages

PUT_LINE package

(see also p package)
5.2. p: a DBMS_OUTPUT Substitute, Advanced Oracle PL/SQL Programming with Packages

PUT_LINE procedure: 2.8.1.1. Supporting many data combinations, Advanced Oracle PL/SQL Programming with Packages

buffer size: 6.1.2.1. The DBMS_OUTPUT.ENABLE procedure, Oracle Built-in Packages

concepts: 6.1.1.2. DBMS_OUTPUT concepts, Oracle Built-in Packages

creating: 6.1.1. Getting Started with DBMS_OUTPUT, Oracle Built-in Packages

data structures: 6.1.1.4. DBMS_OUTPUT nonprogram elements, Oracle Built-in Packages

datatypes supported: 6.1.1.2. DBMS_OUTPUT concepts, Oracle Built-in Packages

drawbacks: 6.1.1.5. Drawbacks of DBMS_OUTPUT, Oracle Built-in Packages

encapsulating: 6.1.6.1. Encapsulating DBMS_OUTPUT, Oracle Built-in Packages

example: 6.1.6. DBMS_OUTPUT Examples, Oracle Built-in Packages

exceptions: 6.1.1.3. DBMS_OUTPUT exceptions, Oracle Built-in Packages

unhandled exceptions: 6.1.5. Tips on Using DBMS_OUTPUT, Oracle Built-in Packages

pinning in SGA shared pool: 25.2.2.1. Candidates for pinning in the shared pool, Oracle PL/SQL Programming

privileges: 6.1.1. Getting Started with DBMS_OUTPUT, Oracle Built-in Packages

programs contained in: 6.1.1.1. DBMS_OUTPUT programs, Oracle Built-in Packages

tips for using: 6.1.5. Tips on Using DBMS_OUTPUT, Oracle Built-in Packages

DBMS_PIPE package

(see also message buffers; messages (pipes)
1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.5.1.1. Leveraging builtin packages, Advanced Oracle PL/SQL Programming with Packages
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
3.1. DBMS_PIPE: Communicating Between Sessions , Oracle Built-in Packages
3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
2.4.1. Using Autonomous Transactions from Within SQL, Guide to Oracle8i Features
6.2.1.3. Trapping system errors, Guide to Oracle8i Features
C.10. DBMS_PIPE, Oracle PL/SQL Programming
PL/SQL server implementation using: 3.1.7.4. Implementing a server program, Oracle Built-in Packages
applications of: 3.1. DBMS_PIPE: Communicating Between Sessions , Oracle Built-in Packages
creating: 3.1.1. Getting Started with DBMS_PIPE, Oracle Built-in Packages
examples: 3.1.7. DBMS_PIPE Examples, Oracle Built-in Packages
exceptions: 3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
external services and: 3.1.7.1. Communicating with the outside world, Oracle Built-in Packages
logging and: 3.1.7.4. Implementing a server program, Oracle Built-in Packages
nontransactional behavior: 3.1.2.2. Nontransactional communications, Oracle Built-in Packages
privileges: 3.1.1. Getting Started with DBMS_PIPE, Oracle Built-in Packages
programs contained in: 3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
sending/receiving relationship: 3.1.7.3. The dbpipe utility package, Oracle Built-in Packages
tips on using: 3.1.6. Tips on Using DBMS_PIPE, Oracle Built-in Packages

DBMS_PROFILER package

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i), Guide to Oracle8i Features
7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_RANDOM package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
10.4. DBMS_RANDOM: Generating Random Numbers (Oracle8 Only), Oracle Built-in Packages
10.4.1. Getting Started with DBMS_RANDOM, Oracle Built-in Packages
creating: 10.4.1. Getting Started with DBMS_RANDOM, Oracle Built-in Packages
exceptions: 10.4.1. Getting Started with DBMS_RANDOM, Oracle Built-in Packages
privileges: 10.4.1. Getting Started with DBMS_RANDOM, Oracle Built-in Packages
programs contained in: 10.4.1. Getting Started with DBMS_RANDOM, Oracle Built-in Packages

DBMS_RECTIFIER_DIFF package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
15.5. DBMS_RECTIFIER_DIFF: Comparing Replicated Tables, Oracle Built-in Packages
15.5.1. Getting Started with DBMS_RECTIFIER_DIFF, Oracle Built-in Packages
creating: 15.5.1. Getting Started with DBMS_RECTIFIER_DIFF, Oracle Built-in Packages
exceptions: (see specific program names)
privileges: 15.5.1. Getting Started with DBMS_RECTIFIER_DIFF, Oracle Built-in Packages
programs contained in: 15.5.1. Getting Started with DBMS_RECTIFIER_DIFF, Oracle Built-in Packages

DBMS_REFRESH package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
14.2. DBMS_REFRESH: Managing Snapshot Groups, Oracle Built-in Packages
14.2.1. Getting Started with DBMS_REFRESH, Oracle Built-in Packages
creating: 14.2.1. Getting Started with DBMS_REFRESH, Oracle Built-in Packages
exceptions: 14.2.1. Getting Started with DBMS_REFRESH, Oracle Built-in Packages
privileges: 14.2.1. Getting Started with DBMS_REFRESH, Oracle Built-in Packages
programs contained in: 14.2.1. Getting Started with DBMS_REFRESH, Oracle Built-in Packages

DBMS_REPAIR package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_REPCAT package

(see also specific program names)

1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages

14.4. DBMS_REPCAT: Managing Snapshot Replication Groups, Oracle Built-in Packages

15.3.1. Getting Started with DBMS_REPCAT, Oracle Built-in Packages

15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages

16. Conflict Resolution, Oracle Built-in Packages

creating

14.4.1. Getting Started with DBMS_REPCAT, Oracle Built-in Packages
15.3.1. Getting Started with DBMS_REPCAT, Oracle Built-in Packages
16.1. Getting Started with DBMS_REPCAT, Oracle Built-in Packages

data dictionary views: 16.1.4. Data Dictionary Views, Oracle Built-in Packages

exceptions

14.4.1.2. DBMS_REPCAT exceptions, Oracle Built-in Packages
15.3.1.2. Exceptions, Oracle Built-in Packages
16.1.2. DBMS-REPCAT Exceptions, Oracle Built-in Packages

privileges

14.4.1. Getting Started with DBMS_REPCAT, Oracle Built-in Packages
15.3.1. Getting Started with DBMS_REPCAT, Oracle Built-in Packages
16.1. Getting Started with DBMS_REPCAT, Oracle Built-in Packages

programs contained in

14.4.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages

DBMS_REPCAT_ADMIN package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
15.2. DBMS_REPCAT_ADMIN: Setting Up More Administrator Accounts, Oracle Built-in Packages
15.2.1.1. DBMS_REPCAT_ADMIN programs, Oracle Built-in Packages
creating: 15.2.1. Getting Started with DBMS_REPCAT_ADMIN, Oracle Built-in Packages
exceptions: 15.2.1.2. DBMS_REPCAT_ADMIN exceptions, Oracle Built-in Packages
privileges: 15.2.1. Getting Started with DBMS_REPCAT_ADMIN, Oracle Built-in Packages
programs contained in: 15.2.1.1. DBMS_REPCAT_ADMIN programs, Oracle Built-in Packages

DBMS_REPCAT_AUTH package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
15.1.1. Getting Started with DBMS_REPCAT_AUTH, Oracle Built-in Packages
15.1.1.1. DBMS_REPCAT_AUTH programs, Oracle Built-in Packages
creating: 15.1.1. Getting Started with DBMS_REPCAT_AUTH, Oracle Built-in Packages
exceptions: 15.1.1.2. DBMS_REPCAT_AUTH exceptions, Oracle Built-in Packages
privileges: 15.1.1. Getting Started with DBMS_REPCAT_AUTH, Oracle Built-in Packages
programs contained in: 15.1.1.1. DBMS_REPCAT_AUTH programs, Oracle Built-in Packages

DBMS_REPCAT_FLA package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_REPCAT_FLA_MAS package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_REPCAT_FLA_UTL package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_REPUTIL package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
15.6. DBMS_REPUTIL: Enabling and Disabling Replication, Oracle Built-in Packages
15.6.1. Getting Started with DBMS_REPUTIL, Oracle Built-in Packages
programs contained in: 15.6.1. Getting Started with DBMS_REPUTIL, Oracle Built-in Packages

DBMS_RESOURCE_MANAGER package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_RESOURCE_MANAGER_PRIVS package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_RLS package

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i), Guide to Oracle8i Features
7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features
7.3. DBMS_RLS: Implementing Fine-Grained Access Control, Guide to Oracle8i Features
8.1. FGAC Components, Guide to Oracle8i Features

DBMS_ROWID package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
9.1. DBMS_ROWID: Working with the ROWID Pseudo-Column (Oracle8 only), Oracle Built-in Packages
9.1.1.1. DBMS_ROWID programs, Oracle Built-in Packages
C.11. DBMS_ROWID (PL/SQL8 Only), Oracle PL/SQL Programming
creating: 9.1.1. Getting Started with DBMS_ROWID, Oracle Built-in Packages
data structures: 9.1.1.3. DBMS_ROWID nonprogram elements, Oracle Built-in Packages
exceptions: 9.1.1.2. DBMS_ROWID exceptions, Oracle Built-in Packages
privileges: 9.1.1. Getting Started with DBMS_ROWID, Oracle Built-in Packages
programs contained in: 9.1.1.1. DBMS_ROWID programs, Oracle Built-in Packages

DBMS_RULE package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_RULE_ADM package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_RULE_EXIMP package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_SESSION package

(see also specific program names)
1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
11.1. DBMS_SESSION: Managing Session Information, Oracle Built-in Packages
11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
C.12. DBMS_SESSION, Oracle PL/SQL Programming
creating: 11.1.1. Getting Started with DBMS_SESSION, Oracle Built-in Packages
enhancing: 11.1.5.1. Adding value to DBMS_SESSION, Oracle Built-in Packages
exceptions: 11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
privileges: 11.1.1. Getting Started with DBMS_SESSION, Oracle Built-in Packages
program use: 11.1.5. DBMS_SESSION Examples, Oracle Built-in Packages
programs contained in: 11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages

DBMS_SHARED_POOL package

(see also specific program names)
1.4.3.1. Managing packages in shared memory, Advanced Oracle PL/SQL Programming with Packages
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
12.2. DBMS_SHARED_POOL: Pinning Objects, Oracle Built-in Packages
12.2.1. Getting Started with DBMS_SHARED_POOL, Oracle Built-in Packages
25.2.2. Pin Critical Code into the SGA, Oracle PL/SQL Programming
creating: 12.2.1. Getting Started with DBMS_SHARED_POOL, Oracle Built-in Packages
examples: 12.2.4. DBMS_SHARED_POOL Examples, Oracle Built-in Packages
exceptions: 12.2.1. Getting Started with DBMS_SHARED_POOL, Oracle Built-in Packages
privileges: 12.2.1. Getting Started with DBMS_SHARED_POOL, Oracle Built-in Packages
programs contained in: 12.2.1. Getting Started with DBMS_SHARED_POOL, Oracle Built-in Packages

DBMS_SNAPSHOT package

(see also specific program names)
1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
14.1. DBMS_SNAPSHOT: Managing Snapshots, Oracle Built-in Packages
14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
C.13. DBMS_SNAPSHOT, Oracle PL/SQL Programming
creating: 14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
exceptions: 14.1.2. Using the I_AM_A_REFRESH Package State Variable, Oracle Built-in Packages
privileges: 14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
programs contained in: 14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages

DBMS_SPACE package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
12.1. DBMS_SPACE: Obtaining Space Information, Oracle Built-in Packages
12.1.1. Getting Started with DBMS_SPACE, Oracle Built-in Packages
creating: 12.1.1. Getting Started with DBMS_SPACE, Oracle Built-in Packages
encapsulating: 12.1.3. DBMS_SPACE Examples, Oracle Built-in Packages
exceptions: 12.1.1. Getting Started with DBMS_SPACE, Oracle Built-in Packages
privileges: 12.1.1. Getting Started with DBMS_SPACE, Oracle Built-in Packages
programs contained in: 12.1.1. Getting Started with DBMS_SPACE, Oracle Built-in Packages

DBMS_SPACE_ADMIN package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_SQL compared to native dynamic SQL: 4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features

DBMS_SQL package

(see also specific program names)

1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages

19. PLVdyn and PLVfk: Dynamic SQL and PL/SQL, Advanced Oracle PL/SQL Programming with Packages

19.3. The Dynamic Packages of PL/Vision, Advanced Oracle PL/SQL Programming with Packages

19.5.6.1. Open and parse, Advanced Oracle PL/SQL Programming with Packages

1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages

2. Executing Dynamic SQL and PL/SQL, Oracle Built-in Packages

2.2.3. DBMS_SQL Programs, Oracle Built-in Packages

1.3.2. Invoker Rights (Chapter 3, Invoker Rights: Your Schema or Mine? ), Guide to Oracle8i Features

3.1.4. Dynamic SQL and Definer Rights, Guide to Oracle8i Features

4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features

C.14. DBMS_SQL, Oracle PL/SQL Programming

BIND_VARIABLE: 5.20.8. Miscellaneous PLVobj programs, Advanced Oracle PL/SQL Programming with Packages

DDL statement execution

2. Executing Dynamic SQL and PL/SQL, Oracle Built-in Packages

2.4.7. Executing DDL in PL/SQL, Oracle Built-in Packages

binding versus concatenation: 2.3.4. Binding Values into Dynamic SQL, Oracle Built-in Packages

EXECUTE procedure: 19.5.4. Checking feedback on DML, Advanced Oracle PL/SQL Programming with Packages

Oracle8 datatype restrictions: 2.4.1. Some Restrictions, Oracle Built-in Packages

SQL statements, language version in parsing: 2.2.6. DBMS_SQL Nonprogram Elements, Oracle Built-in Packages

array processing with: 2.5.6. Array Processing with DBMS_SQL, Oracle Built-in Packages

batch processing: 25.3.4. Take Advantage of DBMS_SQL Batch Processing, Oracle PL/SQL Programming

creating: 2.2.1. Creating the DBMS_SQL Package, Oracle Built-in Packages

examples: 2.5. DBMS_SQL Examples, Oracle Built-in Packages

RETURNING clause, use of: 2.5.7. Using the RETURNING Clause in Dynamic SQL, Oracle Built-in Packages

array processing: 2.5.6. Array Processing with DBMS_SQL, Oracle Built-in Packages

displaying table contents with Method 4 dynamic SQL: 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL, Oracle Built-in Packages

encapsulating DESCRIBE_COLUMNS: 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages

generic drop_object procedure: 2.5.1. A Generic Drop_Object Procedure, Oracle Built-in Packages

generic foreign key lookup: 2.5.2. A Generic Foreign Key Lookup Function, Oracle Built-in Packages

indirect referencing: 2.5.5. Indirect Referencing in PL/SQL, Oracle Built-in Packages

exceptions: 2.2.5. DBMS_SQL Exceptions, Oracle Built-in Packages

nested variable restrictions: 2.4.1. Some Restrictions, Oracle Built-in Packages

objects, restrictions on: 2.4.1. Some Restrictions, Oracle Built-in Packages

performance improvement using: 2.4.5. Improving the Performance of Dynamic SQL, Oracle Built-in Packages

privileges

2.2.1. Creating the DBMS_SQL Package, Oracle Built-in Packages
2.4.2. Privileges and Execution Authority with DBMS_SQL, Oracle Built-in Packages

processing flow: 2.3.1. Processing Flow of Dynamic SQL, Oracle Built-in Packages

programs contained in: 2.2.3. DBMS_SQL Programs, Oracle Built-in Packages

variable arrays: 2.4.1. Some Restrictions, Oracle Built-in Packages

DBMS_STANDARD package: 1.4.2. The DBMS_STANDARD Package, Oracle Built-in Packages

pinning in SGA shared pool: 25.2.2.1. Candidates for pinning in the shared pool, Oracle PL/SQL Programming

DBMS_STANDARD packages: 1.2. What Are the Types and Layers of Packages?, Advanced Oracle PL/SQL Programming with Packages

DBMS_STATS package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_SUMMARY package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_SYSTEM package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
11.2. DBMS_System: Setting Events for Debugging, Oracle Built-in Packages
11.2.1. Getting Started with DBMS_SYSTEM , Oracle Built-in Packages
creating: 11.2.1. Getting Started with DBMS_SYSTEM , Oracle Built-in Packages
encapsulating: 11.2.3. DBMS_SYSTEM Examples, Oracle Built-in Packages
exceptions: 11.2.1. Getting Started with DBMS_SYSTEM , Oracle Built-in Packages
privileges: 11.2.1. Getting Started with DBMS_SYSTEM , Oracle Built-in Packages
programs contained in: 11.2.1. Getting Started with DBMS_SYSTEM , Oracle Built-in Packages

DBMS_TRACE package

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i), Guide to Oracle8i Features
7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features
7.2. DBMS_TRACE: Providing a PL/SQL Trace Facility, Guide to Oracle8i Features

DBMS_TRANSACTION package

(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
4.2. DBMS_TRANSACTION: Interfacing to SQL Transaction Statements, Oracle Built-in Packages
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
C.15. DBMS_TRANSACTION, Oracle PL/SQL Programming
commitment: 4.2.3. Committing Data, Oracle Built-in Packages
creating: 4.2.1. Getting Started with DBMS_TRANSACTION, Oracle Built-in Packages
exceptions in: 4.2.1.2. DBMS_TRANSACTION exceptions, Oracle Built-in Packages
privileges: 4.2.1. Getting Started with DBMS_TRANSACTION, Oracle Built-in Packages
programs contained in: 4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
rollback: 4.2.4. Rolling Back Changes, Oracle Built-in Packages
transaction characteristics: 4.2.5. Setting Transaction Characteristics, Oracle Built-in Packages

DBMS_TTS package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

DBMS_UTILITY package

(see also specific program names)
1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
10.1. DBMS_UTILITY: Performing Miscellaneous Operations, Oracle Built-in Packages
10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i), Guide to Oracle8i Features
7.7. New DBMS_UTILITY Features, Guide to Oracle8i Features
C.16. DBMS_UTILITY, Oracle PL/SQL Programming
FORMAT_CALL_STACK function: 21.2.2. Accessing the PL/SQL Call Stack, Advanced Oracle PL/SQL Programming with Packages
GET_TIME Function: 25.1.1. Use the DBMS_UTILITY.GET_TIME Function, Oracle PL/SQL Programming
GET_TIME function: 14. PLVtmr: Analyzing Program Performance, Advanced Oracle PL/SQL Programming with Packages
NAME_RESOLVE procedure: 11.3.2. Converting the Program Name, Advanced Oracle PL/SQL Programming with Packages
creating: 10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
pinning in SGA shared pool: 25.2.2.1. Candidates for pinning in the shared pool, Oracle PL/SQL Programming
privileges: 10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
programs contained in: 10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
tables used by: 10.1.1.1. DBMS_UTILITY nonprogram elements, Oracle Built-in Packages

DBXML package: 9.6. PLSXML Utilities and Demos, Oracle Web Applications

DBXSL package: 9.6. PLSXML Utilities and Demos, Oracle Web Applications

DB_VERSION procedure

10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure, Oracle Built-in Packages

DDL (Data Definition Language)

19.4.1. DDL Operations , Advanced Oracle PL/SQL Programming with Packages
1.3.3. Native Dynamic SQL (Chapter 4, Native Dynamic SQL in Oracle8i), Guide to Oracle8i Features
1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features
DBMS_DDL package for: C.4. DBMS_DDL, Oracle PL/SQL Programming
object privileges and: 18.3.7.1. DDL, Oracle PL/SQL Programming
operations: 5.9.4. Data Definition Language operations, Advanced Oracle PL/SQL Programming with Packages
schemas: 19.5.10.2. Avoiding schema confusion for DDL, Advanced Oracle PL/SQL Programming with Packages

statements

1.4.4.2. Support for DDL and dynamic SQL, Oracle PL/SQL Programming

commitment and: 10.3.1. Getting Started with DBMS_DDL, Oracle Built-in Packages

deferred parsing and: 2.3.4. Binding Values into Dynamic SQL, Oracle Built-in Packages

executing

2. Executing Dynamic SQL and PL/SQL, Oracle Built-in Packages

2.4.7. Executing DDL in PL/SQL, Oracle Built-in Packages

10.1.2.9. The DBMS_UTILITY.EXEC_DDL_STATEMENT procedure, Oracle Built-in Packages

at replicated sites: 15.3.3.4. The DBMS_REPCAT.EXECUTE_DDL procedure, Oracle Built-in Packages

binding versus concatenation: 2.3.4. Binding Values into Dynamic SQL, Oracle Built-in Packages

locking and: 2.4.7. Executing DDL in PL/SQL, Oracle Built-in Packages

privileges and: 2.4.7. Executing DDL in PL/SQL, Oracle Built-in Packages

DEC subtype: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming

DECIMAL subtype: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming

DECLARE keyword, PL/SQL: 6.1. Structured Programming in PL/SQL , Oracle Web Applications

DECLARE statement: 4.6.3. Dynamic PL/SQL , Guide to Oracle8i Features

DECODE function

in MAKE_REF funfction: 20.4.2.3. Working around the ORA-22972 problem, Oracle PL/SQL Programming

DECODE function, replacing with IF: 17.8.4. Replacing DECODEs with IF Statements, Oracle PL/SQL Programming

DEFAULT keyword: 4.4.3. Default Values, Oracle PL/SQL Programming

DEFCALL view: 17.1.2. Data Dictionary Views, Oracle Built-in Packages

DEFCALLDEST view: 17.1.2. Data Dictionary Views, Oracle Built-in Packages

DEFDEFAULTDEST view: 17.1.2. Data Dictionary Views, Oracle Built-in Packages

DEFERROR view: 17.1.2. Data Dictionary Views, Oracle Built-in Packages

DEFERRORCOUNT view: 17.1.2. Data Dictionary Views, Oracle Built-in Packages

DEFINE_ARRAY procedure

2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.5.2. The DBMS_SQL.DEFINE_ARRAY procedure, Oracle Built-in Packages
index-by tables used by: 2.2.6. DBMS_SQL Nonprogram Elements, Oracle Built-in Packages
multiple-row COLUMN_VALUE requires: 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure, Oracle Built-in Packages

DEFINE_ARRAY program: 25.3.4. Take Advantage of DBMS_SQL Batch Processing, Oracle PL/SQL Programming

DEFINE_COLUMN procedure

2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.5.1. The DBMS_SQL.DEFINE_COLUMN procedure, Oracle Built-in Packages
C.14.5. The DEFINE_COLUMN 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
single-row COLUMN_VALUE requires: 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure, Oracle Built-in Packages
tips about: 2.5.4.5. Defining the cursor structure, Oracle Built-in Packages

DEFINE_COLUMN_CHAR procedure: 2.3.5.1. The DBMS_SQL.DEFINE_COLUMN procedure, Oracle Built-in Packages

DEFINE_COLUMN_GROUP procedure

16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.2.2.1. The DBMS_REPCAT.DEFINE_COLUMN_GROUP procedure, Oracle Built-in Packages

DEFINE_COLUMN_LONG procedure: 2.2.3. DBMS_SQL Programs, Oracle Built-in Packages

DEFINE_COLUMN_RAW procedure: 2.3.5.1. The DBMS_SQL.DEFINE_COLUMN procedure, Oracle Built-in Packages

DEFINE_COLUMN_ROWID procedure: 2.3.5.1. The DBMS_SQL.DEFINE_COLUMN procedure, Oracle Built-in Packages

DEFINE_PRIORITY_GROUP procedure

16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.3.2.1. The DBMS_REPCAT.DEFINE_PRIORITY_GROUP procedure, Oracle Built-in Packages

DEFINE_SITE_PRIORITY procedure

16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.4.2.1. The DBMS_REPCAT.DEFINE_SITE_PRIORITY procedure, Oracle Built-in Packages

DEFSCHEDULE view: 17.1.2. Data Dictionary Views, Oracle Built-in Packages

DEFTRAN view: 17.1.2. Data Dictionary Views, Oracle Built-in Packages

DEFTRANDEST view: 17.1.2. Data Dictionary Views, Oracle Built-in Packages

DEL column, *_POLICIES data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features

DELETE procedure: 10.8.2.2. The DELETE procedure, Oracle PL/SQL Programming

THE function with: 19.5.1. The THE Pseudo-function, Oracle PL/SQL Programming
removing collection elements: 19.4.3.2. Removing elements using DELETE, Oracle PL/SQL Programming

DELETE statement

(see also DML statements)

1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features

3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features

4. Native Dynamic SQL in Oracle8i, Guide to Oracle8i Features

6. New Trigger Features in Oracle8i, Guide to Oracle8i Features

10.3. PL/SQL Tables and DML Statements, Oracle PL/SQL Programming

multiple-row deletes

2.5.6.2. Using array processing to delete, Oracle Built-in Packages
2.5.7.2. RETURNING from a multiple-row delete, Oracle Built-in Packages

WHERE CURRENT OF clause: 6.11.2. The WHERE CURRENT OF Clause, Oracle PL/SQL Programming

DELETE_DEFAULT_DEST procedure

17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.2.2. The DBMS_DEFER.SYS.DELETE_DEFAULT_DEST procedure, Oracle Built-in Packages

DELETE_ERROR procedure

17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.4.1. The DBMS_DEFER_SYS.DELETE_ERROR procedure, Oracle Built-in Packages

DELETE_OBJECT procedure: 9.2.5.1. The UTL_REF.DELETE_OBJECT procedure, Oracle Built-in Packages

DELETE_TRAN procedure

17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.4.2. The DBMS_DEFER_SYS.DELETE_TRAN procedure, Oracle Built-in Packages

DEQUEUE option, GRANT_QUEUE_PRIVILEGE procedure: 7.6.3.1. GRANT_QUEUE_PRIVILEGE: Granting queue-level privileges, Guide to Oracle8i Features

DEQUEUE procedure

5.4. DBMS_AQ: Interfacing to Oracle AQ (Oracle8 only), Oracle Built-in Packages
5.4.2.1. The DBMS_AQ.DEQUEUE procedure , Oracle Built-in Packages
C.3.1.2. The DEQUEUE procedure, Oracle PL/SQL Programming
DBMS_AQ package: 7.6.4.2. LISTEN: Listening for messages, Guide to Oracle8i Features

DEQUEUE_ANY option, GRANT_SYSTEM_PRIVILEGE procedure: 7.6.2.1. GRANT_SYSTEM_PRIVILEGE: Granting system-level privileges, Guide to Oracle8i Features

DEREF function

18.4.2.4. DEREF, Oracle PL/SQL Programming
virtual REFs and: 20.4.2.4. DEREF: Interpreting a virtual REF, Oracle PL/SQL Programming

DESCRIBE command: 17.2. Current Sources of Information, Advanced Oracle PL/SQL Programming with Packages

DESCRIBE level: 10.2.2.2. The DESCRIBE level, Oracle Built-in Packages

DESCRIBE_COLUMNS procedure

2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure, Oracle Built-in Packages
declarations needed for: 2.2.6. DBMS_SQL Nonprogram Elements, Oracle Built-in Packages
encapsulating: 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages

DESCRIBE_PROCEDURE procedure

(see also DBMS_DESCRIBE package)
10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure, Oracle Built-in Packages

DESC_T table

describing columns and: 2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure, Oracle Built-in Packages
encapsulating: 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages

DESTROY procedure

14.2.1. Getting Started with DBMS_REFRESH, Oracle Built-in Packages
14.2.2.2. The DBMS_REFRESH.DESTROY procedure, Oracle Built-in Packages

DES_ENCRYPTED_PASSWORD attribute, schema-level event: 6.3. Schema-Level Event Triggers, Guide to Oracle8i Features

DETERMINISTIC keyword

1.3.9. Miscellaneous New Features and Performance Improvements (Chapter 10, More Goodies for Oracle8i PL/SQL Developers), Guide to Oracle8i Features
10.2.2.2. Deterministic functions , Guide to Oracle8i Features

DEV account: 4.4.1. Special Handling for PLVdyn, Advanced Oracle PL/SQL Programming with Packages

DICTIONARY_OBJ_NAME attribute, schema-level events: 6.3. Schema-Level Event Triggers, Guide to Oracle8i Features

DICTIONARY_OBJ_OWNER attribute, schema-level events: 6.3. Schema-Level Event Triggers, Guide to Oracle8i Features

DICTIONARY_OBJ_TYPE attribute, schema-level events: 6.3. Schema-Level Event Triggers, Guide to Oracle8i Features

DIFFERENCES procedure: 15.5.2.1. The DBMS_RECTIFIER.DIFFERENCES procedure, Oracle Built-in Packages

DISABLE procedure

6.1.1.1. DBMS_OUTPUT programs, Oracle Built-in Packages
6.1.2.2. The DBMS_OUTPUT.DISABLE procedure, Oracle Built-in Packages
C.9.1. The DISABLE procedure, Oracle PL/SQL Programming

DISABLED function

17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.4.3. The DBMS_DEFER_SYS.DISABLED function, Oracle Built-in Packages

DLL (Dynamic Link Library): 1.3.8.4. InternetLite server and API, Oracle Web Applications

DMBS_ALERT package: C.2. DBMS_ALERT, Oracle PL/SQL Programming

DMBS_LOCK page

SLEEP procedure: 17.5.6.1. A futile first effort, Advanced Oracle PL/SQL Programming with Packages

DML (Data Manipulation Language)

1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!), Guide to Oracle8i Features
1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
encapsulating in object views: 20.2. INSTEAD OF Triggers, Oracle PL/SQL Programming
encapsulating in packages: 18.5.4. Approach 4: Use an Object and a PL/SQL Container Package, Oracle PL/SQL Programming
object privileges and: 18.3.7.2. DML, Oracle PL/SQL Programming

DML statements

1.6.1.5. Isolate volatile areas of functionality, Advanced Oracle PL/SQL Programming with Packages
19.5. DML Operations, Advanced Oracle PL/SQL Programming with Packages
1.4.4.2. Support for DDL and dynamic SQL, Oracle PL/SQL Programming
and tables: 10.3. PL/SQL Tables and DML Statements, Oracle PL/SQL Programming
propagating to remote sites: 15.3.4. Replication Support with DBMS_REPCAT, Oracle Built-in Packages
propagating to replicated tables: 14.1.2.1. The DBMS_SNAPSHOT.I_AM_A_REFRESH function, Oracle Built-in Packages

DNS (Domain Name Server): 2.2.1. The TCP/IP Network, Oracle Web Applications

DOS

1.2.1.1. Finding what you need, Oracle Web Applications
DOS delimiter: 13.2.1. Setting the Operating System Delimiter, Advanced Oracle PL/SQL Programming with Packages

DOUBLE PRECISION subtype: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming

DO_DEFERRED_REPCAT_ADMIN procedure

15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.6.1. The DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN procedure, Oracle Built-in Packages

DROP JAVA statement: 9.1. Oracle8i and Java, Guide to Oracle8i Features

DROP TYPE statement: 18.3.2. CREATE TYPE and DROP TYPE: Creating and Dropping Types, Oracle PL/SQL Programming

DROP command

20.3.2. DROP: Dropping Views and Triggers, Oracle PL/SQL Programming
21.3.3. DROP: Dropping Libraries, Oracle PL/SQL Programming
23.5.3. Changing Stored Objects, Oracle PL/SQL Programming

DROP statement

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
6.3. Schema-Level Event Triggers, Guide to Oracle8i Features

DROP_<conflicttype>_RESOLUTION

16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.5.1.2. The DBMS_REPCAT.DROP_<conflicttype>_RESOLUTION procedure, Oracle Built-in Packages

DROP_COLUMN_GROUP procedure

16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.2.2.2. The DBMS_REPCAT.DROP_COLUMN_GROUP procedure, Oracle Built-in Packages

DROP_DELETE_RESOLUTION procedure: 16.5.1.2. The DBMS_REPCAT.DROP_<conflicttype>_RESOLUTION procedure, Oracle Built-in Packages

DROP_GROUPED_COLUMN procedure

16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.2.3.2. The DBMS_REPCAT.DROP_GROUPED_COLUMN procedure, Oracle Built-in Packages

DROP_MASTER_REPGROUP procedure

15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.2.2. The DBMS_REPCAT.DROP_MASTER_REPGROUP procedure, Oracle Built-in Packages

DROP_MASTER_REPOBJECT procedure

15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure, Oracle Built-in Packages

DROP_POLICY procedure, DBMS_RLS package

7.3.2. DBMS_RLS Programs, Guide to Oracle8i Features
7.3.6. DROP_POLICY: Dropping a Policy, Guide to Oracle8i Features

DROP_PRIORITY procedure

16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.3.4.1. The DBMS_REPCAT.DROP_PRIORITY procedure, Oracle Built-in Packages

DROP_PRIORITY_<datatype> procedure

16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.3.4.2. The DBMS_REPCAT.DROP_PRIORITY_<datatype> procedure, Oracle Built-in Packages

DROP_PRIORITY_GROUP procedure

16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.3.2.2. The DBMS_REPCAT.DROP_PRIORITY_GROUP procedure, Oracle Built-in Packages

DROP_QUEUE procedure

C.3.2.5. The DROP_QUEUE procedure, Oracle PL/SQL Programming
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.4.2. The DBMS_AQADM.DROP_QUEUE procedure, Oracle Built-in Packages

DROP_QUEUE_TABLE procedure

5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.4.3. The DBMS_AQADM.DROP_QUEUE_TABLE procedure, Oracle Built-in Packages
C.3.2.2. The DROP_QUEUE_TABLE procedure, Oracle PL/SQL Programming

DROP_SITE_PRIORITY procedure

16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.4.2.2. The DBMS_REPCAT.DROP_SITE_PRIORITY procedure, Oracle Built-in Packages

DROP_SITE_PRIORITY_SITE procedure

16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.4.3.2. The DBMS_REPCAT.DROP_SITE_PRIORITY_SITE procedure, Oracle Built-in Packages

DROP_SNAPSHOT procedure: C.13.1. The DROP_SNAPSHOT procedure, Oracle PL/SQL Programming

DROP_SNAPSHOT_REPGROUP procedure

14.4.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
14.4.2.3. The DBMS_REPCAT.DROP_SNAPSHOT_REPGROUP procedure, Oracle Built-in Packages

DROP_SNAPSHOT_REPOBJECT procedure

14.4.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
14.4.3.2. The DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT procedure, Oracle Built-in Packages

DROP_UNIQUE_RESOLUTION procedure: 16.5.1.2. The DBMS_REPCAT.DROP_<conflicttype>_RESOLUTION procedure, Oracle Built-in Packages

DROP_UPDATE_RESOLUTION procedure: 16.5.1.2. The DBMS_REPCAT.DROP_<conflicttype>_RESOLUTION procedure, Oracle Built-in Packages

DTD (document type definition): 9.3. The Document Type Definition (DTD), Oracle Web Applications

DUMP function: 13.3.1. The DUMP function, Oracle PL/SQL Programming

DUP_VAL_ON_INDEX exception: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

Data Definition Language (DDL)

19.4.1. DDL Operations , Advanced Oracle PL/SQL Programming with Packages
1.3.3. Native Dynamic SQL (Chapter 4, Native Dynamic SQL in Oracle8i), Guide to Oracle8i Features
1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features

Data Definition Language statements: (see DDL statements)

Data Manipulation Language (DML)

1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!), Guide to Oracle8i Features
1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features

Data Manipulation Language statements: (see DML statements)

Database Access Descriptor (DAD)

2.2.5. The Uniform Resource Locator, Oracle Web Applications
2.3. Content Delivery Model, Oracle Web Applications
3.2.2. Configuring a Database Access Descriptor (DAD), Oracle Web Applications
parameters: 3.2.2.1. DAD parameters, Oracle Web Applications

Default (Home) Page parameter, DAD: 3.2.2.1. DAD parameters, Oracle Web Applications

Developer/2000

18.5.5. Implications for Developer/2000, Oracle PL/SQL Programming
1.3.8.1. Oracle Lite, Oracle Web Applications

Document Access Path parameter, DAD: 3.2.2.1. DAD parameters, Oracle Web Applications

Document Access Procedure parameter, DAD: 3.2.2.1. DAD parameters, Oracle Web Applications

Document Table parameter, DAD: 3.2.2.1. DAD parameters, Oracle Web Applications

Domain Name Server (DNS): 2.2.1. The TCP/IP Network, Oracle Web Applications

Dynamic Link Library (DLL): 1.3.8.4. InternetLite server and API, Oracle Web Applications

dangling REFs: 18.2.3. Adding Complex Data Structures, Oracle PL/SQL Programming

data

abstract datatypes: (see ADTs)

abstraction: 9.1.3.1. Data abstraction, Oracle PL/SQL Programming

changing accessibility of: 1.4.4.2. Switching between public and private, Advanced Oracle PL/SQL Programming with Packages

combining scalars and aggregates: 17.8.2. Combining Scalar and Aggregate Values, Oracle PL/SQL Programming

controlling with packages: 1.6.1.2. Maintain control over your data structures, Advanced Oracle PL/SQL Programming with Packages

denormalizing with nested records: 9.7.4. Denormalizing Program Data with Nested Records, Oracle PL/SQL Programming

error, consistency of: 22.2.1.1. Recording consistent error data, Advanced Oracle PL/SQL Programming with Packages

errors by implicit cursors: 6.3.2.2. Vulnerability to data errors, Oracle PL/SQL Programming

from packages, performance and: 25.4.4. Use Package Data to Avoid Passing "Bulky" Parameter Values, Oracle PL/SQL Programming

global

16.1.4. Object Persistence, Oracle PL/SQL Programming

16.5.2. Global Within a Single Oracle Session, Oracle PL/SQL Programming

22.5.4. Avoid Global Variables and Data Structures , Oracle PL/SQL Programming

2.10.3. Simplifying Package Interfaces

private: 16.5.4. Global Private Data, Oracle PL/SQL Programming

public: 16.5.3. Global Public Data, Oracle PL/SQL Programming

managing with Oracle: 1.3.9. Oracle interMedia, Oracle Web Applications

object model and: 18.1.5.4. Combining data with behavior , Oracle PL/SQL Programming

package

(see also packages)
16.5. Package Data, Oracle PL/SQL Programming

program: (see variables)

program assumptions on: 3.7. Handling Program Assumptions, Advanced Oracle PL/SQL Programming with Packages

records: (see records)

supporting with overloading

2.8.1.1. Supporting many data combinations, Advanced Oracle PL/SQL Programming with Packages
2.8.1.3. Unambiguous, simple arguments, Advanced Oracle PL/SQL Programming with Packages

tuning access to: 25.3. Tuning Access to Your Data, Oracle PL/SQL Programming

types of: 1.1. The Internet Grows Up, Oracle Web Applications

verifying: 24.2.7. Test All Assumptions, Oracle PL/SQL Programming

data abstraction: 18.1.5.3. Abstraction , Oracle PL/SQL Programming

data block addresses

block numbers, returning

9.1.3.1. The DBMS_ROWID.ROWID_BLOCK_NUMBER function, Oracle Built-in Packages
10.1.2.6. The DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK function, Oracle Built-in Packages

constructing: 10.1.2.16. The DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS function, Oracle Built-in Packages

dropped files and: 9.1.3.8. The DBMS_ROWID.ROWID_TO_EXTENDED function, Oracle Built-in Packages

file numbers, returning: 10.1.2.7. The DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE function, Oracle Built-in Packages

data dictionary

external procedure entries: 21.6.1. Data Dictionary, Oracle PL/SQL Programming
for managing collections: 19.8.2. Data Dictionary, Oracle PL/SQL Programming
object types entries: 18.6.1. Data Dictionary, Oracle PL/SQL Programming
object views entries: 20.7.1. Data Dictionary, Oracle PL/SQL Programming

data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features

data models: 8.3.2. Data Model, Oracle Web Applications

data structures

synchronizing: 1.7.2. Synchronize Program and Data Structures, Oracle PL/SQL Programming
OWA_TEXT package: 7.2.1.1. Data structures, Oracle Web Applications

database administration

1.3.5. WebDB, Oracle Web Applications
3.1.1. Database Administration, Oracle Web Applications

database administrators (DBA)

7.6.2. System-Level Access Control, Guide to Oracle8i Features
1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i), Guide to Oracle8i Features

database code repository: 12.2.2. Database Source or Target, Advanced Oracle PL/SQL Programming with Packages

database event publication feature: 6. New Trigger Features in Oracle8i, Guide to Oracle8i Features

database events: (see alerts)

database intengration: 2.4. Database Integration, Oracle Web Applications

database links

advanced replication and: 15.1.2. Granting and Revoking Surrogate SYS Accounts, Oracle Built-in Packages

closing: 11.1.4.1. The DBMS_SESSION.CLOSE_DATABASE_LINK procedure, Oracle Built-in Packages

enhancement: 11.1.5.5. The close_links procedure, Oracle Built-in Packages

deferred transactions and: 17.2.2.1. The DBMS_DEFER.SYS.ADD_DEFAULT_DEST procedure, Oracle Built-in Packages

job execution and: 13.1.2.2. The what parameter, Oracle Built-in Packages

job scheduling and: 13.2.2. Job Execution and the Job Execution Environment, Oracle Built-in Packages

names for

parsing: 10.1.2.18. The DBMS_UTILITY.NAME_TOKENIZE procedure, Oracle Built-in Packages

returning: 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages

database logins, tracking: 6.2.1.2. Tracking logins to the database, Guide to Oracle8i Features

database object wizards: 3.1.2.1. Building database objects, Oracle Web Applications

database objects: 2.5.2. Database Objects, Oracle Web Applications

database security: 2.5. Database Security Review, Oracle Web Applications

objects: 2.5.2. Database Objects, Oracle Web Applications
privileges: 2.5.3. Privileges, Oracle Web Applications
users: 2.5.1. Database Users, Oracle Web Applications

database segments, extended ROWID format and: 9.1.2. ROWID Concepts, Oracle Built-in Packages

database tables: (see tables)

database-level event triggers

1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!), Guide to Oracle8i Features
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
6.2. Database-Level Event Triggers, Guide to Oracle8i Features

databases

(see also remote databases)
5.1.4. Propagation Features, Oracle Built-in Packages
PLVcat tables: 18.2.2. The PLVcat Database Tables, Advanced Oracle PL/SQL Programming with Packages
administration of: About the Contents, Oracle PL/SQL Programming
communication between sessions: C.10. DBMS_PIPE, Oracle PL/SQL Programming
cursor-based access to: 1.4.3.8. Cursor-based access to the database, Oracle PL/SQL Programming
events, receiving notification of: C.2. DBMS_ALERT, Oracle PL/SQL Programming
locking records: 6.11. SELECT FOR UPDATE in Cursors, Oracle PL/SQL Programming
managing code in: 23. Managing Code in the Database, Oracle PL/SQL Programming
shutdown and job queue: 13.2.1.3. JOB_QUEUE_KEEP_CONNECTIONS, Oracle Built-in Packages
space utilization: 12.1. DBMS_SPACE: Obtaining Space Information, Oracle Built-in Packages
structure for objects: 18.2.2.2. DDL usage , Oracle PL/SQL Programming
synchroniztion with columns: 4.5.1.1. Synchronization with database columns, Oracle PL/SQL Programming
triggers: (see triggers)
tuning of: About the Contents, Oracle PL/SQL Programming
version information: 10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure, Oracle Built-in Packages

datatype indicators, HTP package: 7.1.1. HTP: Generating HTML, Oracle Web Applications

datatype mappings, legal: 9.8.3. Mapping Datatypes, Guide to Oracle8i Features

datatype value, PL/SQL: 6.2.2.1. Declaring a variable, Oracle Web Applications

datatypes

(see also types)

4.2. Scalar Datatypes , Oracle PL/SQL Programming

Oracle8

2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure, Oracle Built-in Packages
2.4.1. Some Restrictions, Oracle Built-in Packages

PL/SQL Version 2.0: B.2.1. No Server-Side PL/SQL Datatypes, Oracle PL/SQL Programming

abstract (see abstract datatypes)

anchored

1.6.1. Anchored declarations, Oracle PL/SQL Programming
4.5. Anchored Declarations, Oracle PL/SQL Programming

collections as: 19.2.2. Collections in PL/SQL, Oracle PL/SQL Programming

constrained/unconstrained: 4.4.1. Constrained Declarations, Oracle PL/SQL Programming

converting

performance and: 25.4.7. Avoid Type Conversions When Possible, Oracle PL/SQL Programming

converting between

4.2.8. Conversion Between Datatypes, Oracle PL/SQL Programming
14. Conversion Functions, Oracle PL/SQL Programming

declaring in tables

10.4.1. Defining the Table TYPE, Oracle PL/SQL Programming
10.8.1. PL/SQL Tables of Records, Oracle PL/SQL Programming

external procedures and: 21.4.1. Datatype Conversion, Oracle PL/SQL Programming

determining (example): 2.5.4.3. Constructing the SELECT, Oracle Built-in Packages

external: 21.4.1. Datatype Conversion, Oracle PL/SQL Programming

for LOB variables: 1.4.7.6. Large object support, Oracle PL/SQL Programming

for LOBs: 4.2.7. LOB Datatypes, Oracle PL/SQL Programming

for overloaded modules: 15.8.4. Restrictions on Overloading, Oracle PL/SQL Programming

message structure and: 5.1.1. General Features, Oracle Built-in Packages

numeric values for: 3.1.4.7. The DBMS_PIPE.NEXT_ITEM_TYPE function, Oracle Built-in Packages

DBMS_DEFER_QUERY: 17.4.1.2. DBMS_DEFER_QUERY nonprogram elements, Oracle Built-in Packages

DESCRIBE_COLUMNS: 2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure, Oracle Built-in Packages

DESCRIBE_PROCEDURE: 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure, Oracle Built-in Packages

GET_ARG_TYPE: 17.4.1.3. The DBMS_DEFER_QUERY.GET_ARG_TYPE function, Oracle Built-in Packages

UNPACK_MESSAGE: 3.1.4.4. The DBMS_PIPE.UNPACK_MESSAGE procedure, Oracle Built-in Packages

object: (see object types)

of stored functions parameters: 17.3. Requirements for Stored Functions in SQL, Oracle PL/SQL Programming

programmer-defined: (see subtypes)

standardizing with %TYPE: 4.7.8. Use %TYPE to Standardize Nondatabase Declarations, Oracle PL/SQL Programming

date

12. Date Functions, Oracle PL/SQL Programming

14.3.5. Building a Date Manager, Oracle PL/SQL Programming

DATE datatype: 4.2.5. The Date-Time Datatype, Oracle PL/SQL Programming

changing millenia: 14.3.3. RR: Changing Millenia, Oracle PL/SQL Programming

converting strings to/from

14.1. Conversion Formats, Oracle PL/SQL Programming
14.2.6. The TO_CHAR function (date conversion), Oracle PL/SQL Programming
14.2.8. The TO_DATE function, Oracle PL/SQL Programming

range: 14.3.4. Using TO_CHAR to Create a Date Range, Oracle PL/SQL Programming

system: 12.1.7. The SYSDATE function, Oracle PL/SQL Programming

date and time: 6.4.3. Retrieving Date and Time, Advanced Oracle PL/SQL Programming with Packages

date format mask

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
7.1.2. Displaying Dates, Advanced Oracle PL/SQL Programming with Packages

elapsed time

5.27.5. Retrieving and displaying elapsed time, Advanced Oracle PL/SQL Programming with Packages
14.3. Retrieving and Displaying the Elapsed Time, Advanced Oracle PL/SQL Programming with Packages

elapsed time of: 5.27. PLVtmr: Program Performance Analyzer, Advanced Oracle PL/SQL Programming with Packages

now function: 5.3.6. Miscellaneous programs, Advanced Oracle PL/SQL Programming with Packages

timer: 14. PLVtmr: Analyzing Program Performance, Advanced Oracle PL/SQL Programming with Packages

timer script: 16.2.9. Generating a Timer Script, Advanced Oracle PL/SQL Programming with Packages

updating in tables: 19.5.3. Executing dynamic UPDATEs, Advanced Oracle PL/SQL Programming with Packages

date format (NLS), setting: 11.1.2.3. The DBMS_SESSION.SET_NLS procedure, Oracle Built-in Packages

date warehousing: 1.1. The Internet Grows Up, Oracle Web Applications

date-to/from-raw conversions: 9.2.2.1. Conversion and coercion, Oracle Built-in Packages

datemask function

5.3.3. Setting the date format mask, Advanced Oracle PL/SQL Programming with Packages
6.2. Setting the PL/Vision Date Mask, Advanced Oracle PL/SQL Programming with Packages

db package

(see also specific program names)
1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function , Oracle Built-in Packages
10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure, Oracle Built-in Packages

db_block_buffers function: 10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function , Oracle Built-in Packages

dbgextp.sql script: 21.6.2. Rules and Warnings About External Procedures, Oracle PL/SQL Programming

dblock package

(see also specific program names)
1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
4.1.4.1. The dblock package, Oracle Built-in Packages

dblock.sql : 4.1.4.1. The dblock package, Oracle Built-in Packages

dbmsalrt.sql script

3.2.1. Getting Started with DBMS_ALERT, Oracle Built-in Packages
3.2.3. DBMS_ALERT Examples, Oracle Built-in Packages

dbmsapin.sql script: 7.1. Getting Started with DBMS_APPLICATION_INFO , Oracle Built-in Packages

dbmsdefr.sql script

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

dbmsdesc.sql script

10.2.1. Getting Started with DBMS_DESCRIBE, Oracle Built-in Packages
10.3.1. Getting Started with DBMS_DDL, Oracle Built-in Packages

dbmsgen.sql script: 15.6.1. Getting Started with DBMS_REPUTIL, Oracle Built-in Packages

dbmsjob.sql script: 13.1. Getting Started with DBMS_ JOB, Oracle Built-in Packages

dbmslob.sql script: 8.1. Getting Started with DBMS_LOB, Oracle Built-in Packages

dbmslock.sql script: 4.1.1. Getting Started with DBMS_LOCK, Oracle Built-in Packages

dbmsoctk.sql script: 10.4.1. Getting Started with DBMS_RANDOM, Oracle Built-in Packages

dbmsofln.sql script

14.3.1. Getting Started with DBMS_OFFLINE_SNAPSHOT, Oracle Built-in Packages
15.4.1. Getting Started with DBMS_OFFLINE_OG, Oracle Built-in Packages

dbmsoutp.sql script: 6.1.1. Getting Started with DBMS_OUTPUT, Oracle Built-in Packages

dbmspbp.sql file: 7.1.2. Installing DBMS_PROFILER, Guide to Oracle8i Features

dbmspipe.sql script: 3.1.1. Getting Started with DBMS_PIPE, Oracle Built-in Packages

dbmspool.sql script: 12.2.1. Getting Started with DBMS_SHARED_POOL, Oracle Built-in Packages

dbmsrand.sql script: 10.4.1. Getting Started with DBMS_RANDOM, Oracle Built-in Packages

dbmsrepc.sql script

14.4.1. Getting Started with DBMS_REPCAT, Oracle Built-in Packages
15.1.1. Getting Started with DBMS_REPCAT_AUTH, Oracle Built-in Packages
15.2.1. Getting Started with DBMS_REPCAT_ADMIN, Oracle Built-in Packages
15.3.1. Getting Started with DBMS_REPCAT, Oracle Built-in Packages
15.5.1. Getting Started with DBMS_RECTIFIER_DIFF, Oracle Built-in Packages
16.1. Getting Started with DBMS_REPCAT, Oracle Built-in Packages

dbmssnap.sql script

14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
14.2.1. Getting Started with DBMS_REFRESH, Oracle Built-in Packages

dbmssql.sql script: 2.2.1. Creating the DBMS_SQL Package, Oracle Built-in Packages

dbmsstdx.sql file: 1.4.2. The DBMS_STANDARD Package, Oracle Built-in Packages

dbmsutil.sql script

1.4. Examining Built-in Package Source Code, Oracle Built-in Packages
11.2.1. Getting Started with DBMS_SYSTEM , Oracle Built-in Packages

dbparm package

(see also specific program names)
1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function , Oracle Built-in Packages

dbparm.spp : 10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function , Oracle Built-in Packages

dbpipe package

(see also specific program names)
1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
3.1.7.3. The dbpipe utility package, Oracle Built-in Packages

dbpipe.sql

3.1.7.3. The dbpipe utility package, Oracle Built-in Packages
3.1.3.1. The DBMS_PIPE.CREATE_PIPE function, Oracle Built-in Packages
3.1.3.2. The DBMS_PIPE.REMOVE_PIPE function, Oracle Built-in Packages
3.1.3.4. The DBMS_PIPE.PURGE procedure, Oracle Built-in Packages

dbstart script: 12.2.4.1. Pinning packages automatically, Oracle Built-in Packages

dbtab constant: 5.3.1. PL/Vision constants, Advanced Oracle PL/SQL Programming with Packages

dbver.spp : 10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure, Oracle Built-in Packages

ddl procedure

5.9.4. Data Definition Language operations, Advanced Oracle PL/SQL Programming with Packages
19.4.1.1. Generic DDL interface, Advanced Oracle PL/SQL Programming with Packages
19.5.6.3. Parse for delete, Advanced Oracle PL/SQL Programming with Packages

deadlock example: 2.4. Rules and Restrictions, Guide to Oracle8i Features

deadlocks, notification of: 4.1.2.2. The DBMS_LOCK.REQUEST function, Oracle Built-in Packages

debug procedure: 3.1.7.5. The pipesvr package, Oracle Built-in Packages

debugging

(see also tracing; troubleshooting)

2.6.3.1. The test/debug cycle in PL/SQL, Advanced Oracle PL/SQL Programming with Packages

5.28.1. Package constants, Advanced Oracle PL/SQL Programming with Packages

4.1.1. The Benefits of PL/Vision, Advanced Oracle PL/SQL Programming with Packages

2.3.10.3. The DBMS_SQL.LAST_ROW_ID function, Oracle Built-in Packages

2.5.2. Multiline Comment Syntax, Oracle PL/SQL Programming

24. Debugging PL/SQL, Oracle PL/SQL Programming

7.4.1.1. Debugging, Oracle Web Applications

DBMS_OUTPUT used for: 6.1. DBMS_OUTPUT: Displaying Output, Oracle Built-in Packages

DBMS_PIPE used for

3.1. DBMS_PIPE: Communicating Between Sessions , Oracle Built-in Packages
3.1.2.2. Nontransactional communications, Oracle Built-in Packages
3.1.7.4. Implementing a server program, Oracle Built-in Packages

external procedures: 21.6.2. Rules and Warnings About External Procedures, Oracle PL/SQL Programming

finding code by line number: 23.6.6. Finding the Code for a Line Number, Oracle PL/SQL Programming

last row fetched and: 2.3.10.3. The DBMS_SQL.LAST_ROW_ID function, Oracle Built-in Packages

messages about, in packages: 24.2.9. Build Debugging Messages into Your Packages, Oracle PL/SQL Programming

strategies for: 24.2. Debugging Tips and Strategies, Oracle PL/SQL Programming

tracing PL/SQL execution: 26. Tracing PL/SQL Execution, Oracle PL/SQL Programming

decimal datatypes

4.2.1.2. Decimal numeric datatypes, Oracle PL/SQL Programming
4.2.2. Numeric Subtypes, Oracle PL/SQL Programming

declaration section, PL/SQL: 6.1. Structured Programming in PL/SQL , Oracle Web Applications

declarations

FOR loop indexes: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming

anchored

1.6.1. Anchored declarations, Oracle PL/SQL Programming
4.5. Anchored Declarations, Oracle PL/SQL Programming

commenting: 3.6.5. Comment Declaration Statements, Oracle PL/SQL Programming

formatting: 3.1.5. Formatting Your Declarations, Oracle PL/SQL Programming

forward: 15.9. Forward Declarations, Oracle PL/SQL Programming

in packages

16.3. The Package Specification, Oracle PL/SQL Programming
16.4.1. Declare in Specification or Body, Oracle PL/SQL Programming

of record TYPEs: 9.4.1. Declaring Programmer-Defined Record TYPEs, Oracle PL/SQL Programming

of records

9.2.1. Declaring Records with the %ROWTYPE Attribute, Oracle PL/SQL Programming
9.4.2. Declaring the Record, Oracle PL/SQL Programming

of tables: 10.4. Declaring a PL/SQL Table, Oracle PL/SQL Programming

subtype: 4.6.1. Declaring Subtypes, Oracle PL/SQL Programming

unconstrained: 15.6.1. Defining the Parameters, Oracle PL/SQL Programming

variable: 4.4. Variable Declarations, Oracle PL/SQL Programming

declarative programming: 19.2. Declarative Programming in PL/SQL, Advanced Oracle PL/SQL Programming with Packages

declaring

anchored declarations: 2.10.5. Anchoring to Public Variables, Advanced Oracle PL/SQL Programming with Packages

collection datatypes: 19.3. Syntax for Declaring Collection Datatypes, Oracle PL/SQL Programming

cursor variables: 6.12.3. Declaring REF CURSOR Types and Cursor Variables, Oracle PL/SQL Programming

cursors

16.2.6. Generating a Cursor Declaration, Advanced Oracle PL/SQL Programming with Packages
6.4. Declaring Cursors, Oracle PL/SQL Programming

exceptions raised in declarations: 8.5.3. Exceptions Raised in a Declaration, Oracle PL/SQL Programming

packages: 1.4.1. The Package Specification, Advanced Oracle PL/SQL Programming with Packages

parameters: 21.4.4. Correct Declaration of Properties, Oracle PL/SQL Programming

private before public: 2.2.1. Choosing the Order of Elements, Advanced Oracle PL/SQL Programming with Packages

variables

1.4.1. The Package Specification, Advanced Oracle PL/SQL Programming with Packages
2.10.1. Gaining Control of Your Data, Advanced Oracle PL/SQL Programming with Packages

deep copies: 7.5.2.5. Managing temporary LOBs, Guide to Oracle8i Features

default

PLVlog: 21.1.5.4. Setting the default "rollback to" behavior, Advanced Oracle PL/SQL Programming with Packages

constructor method: 18.3.1. About Object Types, Oracle PL/SQL Programming

date format mask: 6.2. Setting the PL/Vision Date Mask, Advanced Oracle PL/SQL Programming with Packages

directory/folder: 5.11.4. Setting the default directory or location, Advanced Oracle PL/SQL Programming with Packages

line separator: 7.2. The Line Separator, Advanced Oracle PL/SQL Programming with Packages

message table names: 9.2.2. Batch Loading of Message Text, Advanced Oracle PL/SQL Programming with Packages

parameter values

B.2.4. No Default Parameter Values, Oracle PL/SQL Programming
15.6.5. Default Values, Oracle PL/SQL Programming
22.7.5. Default Values and Remote Procedure Calls, Oracle PL/SQL Programming

records: 9.6.2. Record Initialization, Oracle PL/SQL Programming

source WHERE clause: 12.4. The Source WHERE Clause, Advanced Oracle PL/SQL Programming with Packages

string function values: 16.2.3.3. Default values for string functions , Advanced Oracle PL/SQL Programming with Packages

values for variables: 4.4.3. Default Values, Oracle PL/SQL Programming

default directory: 13.2.2. Setting the Default Directory, Advanced Oracle PL/SQL Programming with Packages

default mime type parameter, server settings: 3.2.3.1. Server settings, Oracle Web Applications

default values, PL/SQL

6.1.3. Parameters, Oracle Web Applications
6.2.2.1. Declaring a variable, Oracle Web Applications

defcall.sql : 17.3.2.2. The DBMS_DEFER.CALL procedure, Oracle Built-in Packages

defcdest.sql : 17.3.2.3. The DBMS_DEFER.COMMIT_WORK procedure, Oracle Built-in Packages

deferred execution: 5. Oracle Advanced Queuing, Oracle Built-in Packages

deferred parsing: 2.3.3.1. The DBMS_SQL.PARSE procedure, Oracle Built-in Packages

DDL statements and: 2.3.4. Binding Values into Dynamic SQL, Oracle Built-in Packages

deferred transactions

(see also RPCs)

17.1.1. About Remote Destinations, Oracle Built-in Packages

17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure, Oracle Built-in Packages

Oracle8 propagation scheduling: 17.2.6. Scheduling Propagation (Oracle8 only), Oracle Built-in Packages

commiting

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

data dictionary views for: 17.1.2. Data Dictionary Views, Oracle Built-in Packages

database links and: 17.2.2.1. The DBMS_DEFER.SYS.ADD_DEFAULT_DEST procedure, Oracle Built-in Packages

error handling: 17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure, Oracle Built-in Packages

executing: 17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure, Oracle Built-in Packages

failed transactions

deleting: 17.2.4.1. The DBMS_DEFER_SYS.DELETE_ERROR procedure, Oracle Built-in Packages

executing: 17.2.4.4. The DBMS_DEFER_SYS.EXECUTE_ERROR procedure, Oracle Built-in Packages

named transactions, deleting: 17.2.4.2. The DBMS_DEFER_SYS.DELETE_TRAN procedure, Oracle Built-in Packages

parameterized RPCs: 17.3.3. Parameterized RPCs, Oracle Built-in Packages

parameterless RPCs: 17.3.2. Basic RPCs, Oracle Built-in Packages

propagation: (see propagating transactions)

rate and volume control: 17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure, Oracle Built-in Packages

replication triggers and: 17. Deferred Transactions and Remote Procedure Calls, Oracle Built-in Packages

roles and: 17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure, Oracle Built-in Packages

scheduling: 17.2.5.3. The DBMS_DEFER_SYS.SCHEDULE_EXECUTION procedure, Oracle Built-in Packages

INIT.ORA and: 17.2.5.1. Scheduling strategies, Oracle Built-in Packages

specifying remote destinations: 17.3.2.1. The DBMS_DEFER.TRANSACTION procedure, Oracle Built-in Packages

stopping execution: 17.2.5.4. The DBMS_DEFER_SYS.UNSCHEDULE_EXECUTION procedure, Oracle Built-in Packages

testing if deferred transactions disabled: 17.2.4.3. The DBMS_DEFER_SYS.DISABLED function, Oracle Built-in Packages

define_variable, EXECUTE IMMEDIATE statement: 4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features

definer rights model

18.3.7.3. Rights model, Oracle PL/SQL Programming
7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features

defsched.sql : 17.2.5.3. The DBMS_DEFER_SYS.SCHEDULE_EXECUTION procedure, Oracle Built-in Packages

defstk constant: 5.24.1. Package constants, Advanced Oracle PL/SQL Programming with Packages

deftdest.sql : 17.3.2.3. The DBMS_DEFER.COMMIT_WORK procedure, Oracle Built-in Packages

delete conflicts

16. Conflict Resolution, Oracle Built-in Packages
16.5.1. About Resolution Methods, Oracle Built-in Packages

deleteitem procedure: 5.18.3. Modifying list contents , Advanced Oracle PL/SQL Programming with Packages

deleting

PL/SQL table contents: 21.1.4.1. Counting and clearing the PL/SQL table, Advanced Oracle PL/SQL Programming with Packages

collection elements: 19.4.3. Adding and Removing Elements, Oracle PL/SQL Programming

execution stack contents: 21.2.4.5. Emptying the stack, Advanced Oracle PL/SQL Programming with Packages

files from PL/SQL: 9.3.5. Deleting Files from PL/SQL, Guide to Oracle8i Features

from bailout error list: 22.1.10.1. Managing the bailout error list, Advanced Oracle PL/SQL Programming with Packages

from tables: 19.5.2. Executing dynamic DELETEs, Advanced Oracle PL/SQL Programming with Packages

stacks: 5.24.2. Creating and destroying stacks, Advanced Oracle PL/SQL Programming with Packages

tables: 10.7. Clearing the PL/SQL Table, Oracle PL/SQL Programming

table rows

8.6. Emptying Tables with PLVtab, Advanced Oracle PL/SQL Programming with Packages
10.8.2.2. The DELETE procedure, Oracle PL/SQL Programming

target repository contents: 12.9.3. Clearing the Target, Advanced Oracle PL/SQL Programming with Packages

delim function

5.11.3. Setting the operating system delimiter, Advanced Oracle PL/SQL Programming with Packages
delim procedure: 13.2.1. Setting the Operating System Delimiter, Advanced Oracle PL/SQL Programming with Packages

delimiter

UNIX and MS-DOS

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

customizing: 10.1.2. Customizing the Delimiter Set, Advanced Oracle PL/SQL Programming with Packages

line separator: 7.2. The Line Separator, Advanced Oracle PL/SQL Programming with Packages

operating system

5.11.3. Setting the operating system delimiter, Advanced Oracle PL/SQL Programming with Packages
13.2.1. Setting the Operating System Delimiter, Advanced Oracle PL/SQL Programming with Packages

string: 5.21.1. Package constants, Advanced Oracle PL/SQL Programming with Packages

delret.sp : 2.5.7.2. RETURNING from a multiple-row delete, Oracle Built-in Packages

demohash procedure: 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function, Oracle Built-in Packages

denormalizing program data: 9.7.4. Denormalizing Program Data with Nested Records, Oracle PL/SQL Programming

dependency

identifying with PLVcat: 18.2.4. Identifying References and Dependencies, Advanced Oracle PL/SQL Programming with Packages
management: 23.3. Module Validation and Dependency Management, Oracle PL/SQL Programming
package: 2.4.1. Creating Codependent Packages, Advanced Oracle PL/SQL Programming with Packages

dequeue options record type: 5.3.8. Dequeue Options Record Type, Oracle Built-in Packages

dequeue procedure

5.7.2. Working with Prioritized Queues, Oracle Built-in Packages
5.7.4. Browsing a Queue's Contents, Oracle Built-in Packages

dequeuing: 5.4.2.1. The DBMS_AQ.DEQUEUE procedure , Oracle Built-in Packages

AQ features for: 5.1.3. Dequeue Features, Oracle Built-in Packages

consistency and: 5.4.2.5. Dequeue navigation, Oracle Built-in Packages

correlation identifiers: 5.3.8. Dequeue Options Record Type, Oracle Built-in Packages

example: 5.7.5. Searching by Correlation Identifier, Oracle Built-in Packages

delaying: 5.3.6. Message Properties Record Type, Oracle Built-in Packages

identifying messages: 5.3.8. Dequeue Options Record Type, Oracle Built-in Packages

locking and: 5.3.8. Dequeue Options Record Type, Oracle Built-in Packages

message grouping and: 5.4.2.6. Dequeuing with message grouping, Oracle Built-in Packages

message retrieved next: 5.3.8. Dequeue Options Record Type, Oracle Built-in Packages

messages: 1.3.10.3. Enqueue and dequeue messages to/from a queue, Oracle Web Applications

modifying dequeuing properties (example): 5.4.2.2. Examples, Oracle Built-in Packages

navigation

5.3.8. Dequeue Options Record Type, Oracle Built-in Packages
5.4.2.5. Dequeue navigation, Oracle Built-in Packages

number of attempts: 5.3.6. Message Properties Record Type, Oracle Built-in Packages

processing sequence

5.3.7. Enqueue Options Record Type, Oracle Built-in Packages
5.4.2.4. Dequeue order , Oracle Built-in Packages

search criteria: 5.4.2.3. Dequeue search criteria, Oracle Built-in Packages

transactions and

5.1.3. Dequeue Features, Oracle Built-in Packages
5.3.8. Dequeue Options Record Type, Oracle Built-in Packages

waiting for messages: 5.3.8. Dequeue Options Record Type, Oracle Built-in Packages

desc command (SQL*Plus)

objects and: 18.6.2. SQL*Plus "Describe" Command, Oracle PL/SQL Programming

desccols package

(see also specific program names)
1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages

desccols.spp : 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages

desccols.tst : 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages

desctest package

(see also specific program names)
10.2.3.2. Using psdesc.args as a quality assurance tool, Oracle Built-in Packages

designing programs: (see programming technique)

destroy procedure: 5.18.2. Creating and destroying lists, Advanced Oracle PL/SQL Programming with Packages

destroying: (see deleting)

developer utilities: 4.2.2. Developer Utilities, Advanced Oracle PL/SQL Programming with Packages

developers: 2.5.1. Seeing Developers as Users, Advanced Oracle PL/SQL Programming with Packages

developing web applications: 1.4.2. Develop Web Applications with HTML and PL/SQL, Oracle Web Applications

development

1.3.6. Performance Improvement, Advanced Oracle PL/SQL Programming with Packages
3. The PL/SQL Development Spiral, Advanced Oracle PL/SQL Programming with Packages
best practices for: 1.7. Best Practices for PL/SQL Excellence, Oracle PL/SQL Programming
packages for: 1.7.3. Center All Development Around Packages, Oracle PL/SQL Programming
standarizing environment for: 1.7.4. Standardize Your PL/SQL Development Environment, Oracle PL/SQL Programming
upgrades and fixes: 1.6.1.6. Hide weaknesses to facilitate upgrades and fixes., Advanced Oracle PL/SQL Programming with Packages

development of PL/Vision: 4.1.2. The Origins of PL/Vision, Advanced Oracle PL/SQL Programming with Packages

development platforms: 1.2. Current Web Techniques Are Inadequate, Oracle Web Applications

dicing byte strings: 9.2.2.2. Slicing and dicing, Oracle Built-in Packages

diffcount.sql file: 5.2. Bulk DML with the FORALL Statement, Guide to Oracle8i Features

digital certificates: 2.5.5. Additional Security Precautions, Oracle Web Applications

digits, number of: (see precision)

dir function

5.11.4. Setting the default directory or location, Advanced Oracle PL/SQL Programming with Packages
13.2.2. Setting the Default Directory, Advanced Oracle PL/SQL Programming with Packages

direct field assignment

9.5. Assigning Values to and from Records, Oracle PL/SQL Programming
10.6.1. Direct Assignment, Oracle PL/SQL Programming

directories

aliases

BFILENAME functions and: 13.2.1. The BFILENAME function, Oracle PL/SQL Programming
8.2.2.1. The DIRECTORY object, Oracle Built-in Packages

contents, obtaining: 9.9.1.2. Obtaining directory contents, Guide to Oracle8i Features

creating: 4.2.7.7. Working with BFILEs, Oracle PL/SQL Programming

default: 13.2.2. Setting the Default Directory, Advanced Oracle PL/SQL Programming with Packages

setting default: 5.11.4. Setting the default directory or location, Advanced Oracle PL/SQL Programming with Packages

directory, PL/Vision: 4.3.3. Beginning the Installation, Advanced Oracle PL/SQL Programming with Packages

discrete transactions: 4.2.5.3. The DBMS_TRANSACTION.BEGIN_DISCRETE_TRANSACTION procedure, Oracle Built-in Packages

disk accompanying book

A. What's on the Companion Disk?, Oracle Built-in Packages
A. Appendix: What's on the Companion Disk?, Guide to Oracle8i Features
A. What's on the Companion Disk?, Oracle PL/SQL Programming

disk space: (see memory)

disp_line procedure: 15.4.2.5. Moving to a PL/SQL-based solution, Advanced Oracle PL/SQL Programming with Packages

disp_text procedure: 15.4.1. How to Find Source Code, Advanced Oracle PL/SQL Programming with Packages

display function: 8.2. Displaying PLVtab Tables, Advanced Oracle PL/SQL Programming with Packages

display prefix: 8.5. Setting the Display Prefix, Advanced Oracle PL/SQL Programming with Packages

display procedure

5.11.12. Displaying the contents of a file, Advanced Oracle PL/SQL Programming with Packages
5.17.5. Reading the log , Advanced Oracle PL/SQL Programming with Packages
5.25.8. Displaying a PLVtab table, Advanced Oracle PL/SQL Programming with Packages
8.7. Implementing PLVtab.display, Advanced Oracle PL/SQL Programming with Packages
13.8. Displaying File Contents, Advanced Oracle PL/SQL Programming with Packages
21.1.6. Displaying the Log, Advanced Oracle PL/SQL Programming with Packages

display_atomics procedure

5.21.4. Parsing strings, Advanced Oracle PL/SQL Programming with Packages
10.1.3.2. display_atomics procedure, Advanced Oracle PL/SQL Programming with Packages

display_err procedure: 15.4.2.8. Fine-tuning code display, Advanced Oracle PL/SQL Programming with Packages

display_exception procedure: 22.3.3.4. Displaying the exception, Advanced Oracle PL/SQL Programming with Packages

display_line procedure: 15.4.2.8. Fine-tuning code display, Advanced Oracle PL/SQL Programming with Packages

display_row procedure: 8.7. Implementing PLVtab.display, Advanced Oracle PL/SQL Programming with Packages

display_survey_list procedure, EMP_SURVEY package

8.2.4. The EMP_SURVEY Package, Oracle Web Applications
8.2.4.2. Body, Oracle Web Applications

display_wrap function

5.21.2. Wrapping long strings into paragraphs , Advanced Oracle PL/SQL Programming with Packages
10.1.4.2. display_wrap procedure, Advanced Oracle PL/SQL Programming with Packages
8.2.1. Displaying Wrapped Text, Advanced Oracle PL/SQL Programming with Packages

displaying output: (see output generation)

displaying_module function

5.28.4. Displaying current module, Advanced Oracle PL/SQL Programming with Packages
21.2.1. Directing Output from PLVtrc, Advanced Oracle PL/SQL Programming with Packages

dispmod procedure

5.28.4. Displaying current module, Advanced Oracle PL/SQL Programming with Packages
21.2.1. Directing Output from PLVtrc, Advanced Oracle PL/SQL Programming with Packages

disptab procedure: 5.9.7. Miscellaneous programs, Advanced Oracle PL/SQL Programming with Packages

disptrg procedure

5.15.6. Managing the target repository, Advanced Oracle PL/SQL Programming with Packages
12.7.3. Displaying the Target Repository, Advanced Oracle PL/SQL Programming with Packages

distributed databases

in-doubt transactions: (see in-doubt transactions)
releasing locks and: 4.1.2.2. The DBMS_LOCK.REQUEST function, Oracle Built-in Packages

distributed execution: 1.3.6. Performance Improvement, Advanced Oracle PL/SQL Programming with Packages

distributed transactions: (see deferred transactions; distributed databases)

dml_delete procedure

5.9.5. Data Manipulation Language operations, Advanced Oracle PL/SQL Programming with Packages
19.5.2. Executing dynamic DELETEs, Advanced Oracle PL/SQL Programming with Packages
19.5.6.3. Parse for delete, Advanced Oracle PL/SQL Programming with Packages

dml_insert_select procedure

5.9.5. Data Manipulation Language operations, Advanced Oracle PL/SQL Programming with Packages
19.5.1. Performing an INSERT-SELECT FROM, Advanced Oracle PL/SQL Programming with Packages

dml_update procedure

5.9.5. Data Manipulation Language operations, Advanced Oracle PL/SQL Programming with Packages
19.5.3. Executing dynamic UPDATEs, Advanced Oracle PL/SQL Programming with Packages

do package: 6.1.6.1. Encapsulating DBMS_OUTPUT, Oracle Built-in Packages

do_rb procedure: 21.1.5.6. Performing different kinds of rollbacks, Advanced Oracle PL/SQL Programming with Packages

do_rollback: 5.17.7. Rolling back in PLVlog, Advanced Oracle PL/SQL Programming with Packages

do_rollback procedure: 21.1.5.1. Toggling rollback activity, Advanced Oracle PL/SQL Programming with Packages

document type definition (DTD): 9.3. The Document Type Definition (DTD), Oracle Web Applications

documentation

2.2. Using Effective Coding Style for Packages, Advanced Oracle PL/SQL Programming with Packages

comments: 16.3.7. Generating Online Help Text Stubs, Advanced Oracle PL/SQL Programming with Packages

help generators: 5.13.5. Help generators, Advanced Oracle PL/SQL Programming with Packages

of parameters: 22.7.1. Document All Parameters and Their Functions, Oracle PL/SQL Programming

of programming process: 24.2.6. Document and Back Up Your Efforts, Oracle PL/SQL Programming

online: 17. PLVhlp: Online Help for PL/SQL Programs, Advanced Oracle PL/SQL Programming with Packages

online help

4.4. Installing Online Help for PL/Vision, Advanced Oracle PL/SQL Programming with Packages

4.5. Using Online Help, Advanced Oracle PL/SQL Programming with Packages

5.14. PLVhlp: Online Help Architechture, Advanced Oracle PL/SQL Programming with Packages

12.1. Why PLVio?, Advanced Oracle PL/SQL Programming with Packages

generating: 16.3.7. Generating Online Help Text Stubs, Advanced Oracle PL/SQL Programming with Packages

online reference: 4.3.4. Using the PL/Vision Lite Online Reference , Advanced Oracle PL/SQL Programming with Packages

with encrypted code: 23.7.3. Impact of Encrypting Code, Oracle PL/SQL Programming

dot notation

1.4.2. Referencing Package Elements, Advanced Oracle PL/SQL Programming with Packages

2.3. Selecting Package Names, Advanced Oracle PL/SQL Programming with Packages

2.3.2. Avoiding Redundancy, Advanced Oracle PL/SQL Programming with Packages

B.2.2. No Direct Stored Package Variable References, Oracle PL/SQL Programming

9.1.2. Accessing Record-Based Data, Oracle PL/SQL Programming

18.3.4. Dot Notation, Oracle PL/SQL Programming

parsing

2.5.4.3. Constructing the SELECT, Oracle Built-in Packages
10.1.2.18. The DBMS_UTILITY.NAME_TOKENIZE procedure, Oracle Built-in Packages

referencing package elements: 1.3.3. Referencing Built-in Package Elements, Oracle Built-in Packages

with nested records: 9.7.2. Dot Notation with Nested Records, Oracle PL/SQL Programming

drop_object procedure

5.9.4. Data Definition Language operations, Advanced Oracle PL/SQL Programming with Packages
19.4.1.2. Dropping and truncating objects with PLVdyn, Advanced Oracle PL/SQL Programming with Packages
2.5.1. A Generic Drop_Object Procedure, Oracle Built-in Packages

drop_student procedure: 5.7.4. Browsing a Queue's Contents, Oracle Built-in Packages

dropjava utility

9.1. Oracle8i and Java, Guide to Oracle8i Features
9.5. Using dropjava, Guide to Oracle8i Features

dropobj.sp : 2.5.1. A Generic Drop_Object Procedure, Oracle Built-in Packages

dropping

libraries: 21.3.3. DROP: Dropping Libraries, Oracle PL/SQL Programming
triggers: 20.3.2. DROP: Dropping Views and Triggers, Oracle PL/SQL Programming
views: 20.3.2. DROP: Dropping Views and Triggers, Oracle PL/SQL Programming

dummy programs: 5.2.2.3. Supporting top-down design of modules, Oracle PL/SQL Programming

dump_long procedure: 2.3.8.2. The DBMS_SQL.COLUMN_VALUE_LONG procedure, Oracle Built-in Packages

dumping DDL: (see DDL)

dumplong.sp : 2.3.8.2. The DBMS_SQL.COLUMN_VALUE_LONG procedure, Oracle Built-in Packages

duplicate placeholders

4.4.4. Duplicate Placeholders, Guide to Oracle8i Features
dynamic SQL: 4.4.4. Duplicate Placeholders, Guide to Oracle8i Features

dur parameter, CREATETEMPORARY procedure: 7.5.2.1. CREATETEMPORARY: Creating a temporary LOB, Guide to Oracle8i Features

dynPLSQL program, ndsutil.pkg file: 4.7. NDS Utility Package, Guide to Oracle8i Features

dynamic PL/SQL: 4.6.3. Dynamic PL/SQL , Guide to Oracle8i Features

dynamic SQL

2. Executing Dynamic SQL and PL/SQL, Oracle Built-in Packages

C.14. DBMS_SQL, Oracle PL/SQL Programming

1.4.4.2. Support for DDL and dynamic SQL, Oracle PL/SQL Programming

6.2.1. Types of Cursors, Oracle PL/SQL Programming

DDL statement execution

2. Executing Dynamic SQL and PL/SQL, Oracle Built-in Packages

2.4.7. Executing DDL in PL/SQL, Oracle Built-in Packages

binding versus concatenation: 2.3.4. Binding Values into Dynamic SQL, Oracle Built-in Packages

Method 4: 4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features

Method 4 example: 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL, Oracle Built-in Packages

RETURNING clause in: 2.5.7. Using the RETURNING Clause in Dynamic SQL, Oracle Built-in Packages

blocks

binding host variables and: 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages

index-by tables and: 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages

scope of variables

2.4.8. Executing Dynamic PL/SQL, Oracle Built-in Packages
4.6.3. Dynamic PL/SQL , Guide to Oracle8i Features

syntax for: 2.4.8. Executing Dynamic PL/SQL, Oracle Built-in Packages

cursor variables and: 2.4.1. Some Restrictions, Oracle Built-in Packages

cursors, reusing: 4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features

methods for: 2.2.4. Types of Dynamic SQL, Oracle Built-in Packages

processing flow

2.1. Examples of Dynamic SQL, Oracle Built-in Packages
2.3.1. Processing Flow of Dynamic SQL, Oracle Built-in Packages

tips on using: 2.4. Tips on Using Dynamic SQL, Oracle Built-in Packages

troubleshooting: 2.4.6. Problem-Solving Dynamic SQL Errors, Oracle Built-in Packages

dynamic cursors: 4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features

dynamic ids: 9.2.3. Setting Oracle Privileges, Guide to Oracle8i Features

dynamic linking: 21.1.2. Architecture, Oracle PL/SQL Programming

dynamic page wizard, WebDB: 3.1.2.2. Building user interface components , Oracle Web Applications

dynamic resources

1.2.2. Application Development, Oracle Web Applications
2.1. Resources, Oracle Web Applications

dynconst package: 1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages

dynconst.spp : 1.3.6.1. Referencing packaged constants and variables, Oracle Built-in Packages

dyndel.sp : 2.5.6.2. Using array processing to delete, Oracle Built-in Packages

dyndel.tst : 2.5.6.2. Using array processing to delete, Oracle Built-in Packages

dynins.sp : 2.5.6.1. Using array processing to insert, Oracle Built-in Packages

dynins.tst : 2.5.6.1. Using array processing to insert, Oracle Built-in Packages

dynplsql.sp

2.4.8. Executing Dynamic PL/SQL, Oracle Built-in Packages
4.6.3. Dynamic PL/SQL , Guide to Oracle8i Features

dynsql package

(see also specific program names)
2.4.6. Problem-Solving Dynamic SQL Errors, Oracle Built-in Packages

dynsql.spp : 2.4.6. Problem-Solving Dynamic SQL Errors, Oracle Built-in Packages

dynsql_value package: 1.3.6.1. Referencing packaged constants and variables, Oracle Built-in Packages

dynupd.sp : 2.5.6.3. Using array processing to update, Oracle Built-in Packages

dynupd.tst : 2.5.6.3. Using array processing to update, Oracle Built-in Packages

dynvar package

(see also specific program names)
2.5.5. Indirect Referencing in PL/SQL, Oracle Built-in Packages

dynvar.pkg file: 4.6.3. Dynamic PL/SQL , Guide to Oracle8i Features

dynvar.spp : 2.5.5. Indirect Referencing in PL/SQL, Oracle Built-in Packages

dynvar.tst : 2.5.5. Indirect Referencing in PL/SQL, Oracle Built-in 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