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 </