home | O'Reilly's CD bookshelfs | FreeBSD | Linux | Cisco | Cisco Exam    

CD Home

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

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

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







??????????????@Mail.ru