| |
| |
Preface | |
| |
| |
| |
Overview | |
| |
| |
| |
Introduction | |
| |
| |
The Power of Built-in Packages | |
| |
| |
Built-in Packages Covered in This Book | |
| |
| |
Using Built-in Packages | |
| |
| |
Examining Built-in Package Source Code | |
| |
| |
| |
Application Development Packages | |
| |
| |
| |
Executing Dynamic SQL and PL/SQL | |
| |
| |
Examples of Dynamic SQL | |
| |
| |
Getting Started with DBMS_SQL | |
| |
| |
The DBMS_SQL Interface | |
| |
| |
Tips on Using Dynamic SQL | |
| |
| |
DBMS_SQL Examples | |
| |
| |
| |
Intersession Communication | |
| |
| |
DBMS_PIPE: Communicating Between Sessions | |
| |
| |
DBMS_ALERT: Broadcasting Alerts to Users | |
| |
| |
| |
User Lock and Transaction Management | |
| |
| |
DBMS_LOCK: Creating and Managing Resource Locks | |
| |
| |
DBMS_TRANSACTION: Interfacing to SQL Transaction Statements | |
| |
| |
| |
Oracle Advanced Queuing | |
| |
| |
Oracle AQ Concepts | |
| |
| |
Getting Started with Oracle AQ | |
| |
| |
Oracle AQ Nonprogram Elements | |
| |
| |
DBMS_AQ: Interfacing to Oracle AQ (Oracle8 only) | |
| |
| |
DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only) | |
| |
| |
Oracle AQ Database Objects | |
| |
| |
Oracle AQ Examples | |
| |
| |
| |
Generating Output from PL/SQL Programs | |
| |
| |
DBMS_OUTPUT: Displaying Output | |
| |
| |
UTL_FILE: Reading and Writing Server-side Files | |
| |
| |
| |
Defining an Application Profile | |
| |
| |
Getting Started with DBMS_APPLICATION_INFO | |
| |
| |
DBMS_APPLICATION_INFO Interface | |
| |
| |
DBMS_APPLICATION_INFO Examples | |
| |
| |
| |
Managing Large Objects | |
| |
| |
Getting Started with DBMS_LOB | |
| |
| |
LOB Concepts | |
| |
| |
DBMS_LOB Interface | |
| |
| |
| |
Datatype Packages | |
| |
| |
DBMS_ROWID: Working with the ROWID Pseudo-Column (Oracle8 only) | |
| |
| |
UTL_RAW: Manipulating Raw Data | |
| |
| |
UTL_REF: Referencing Objects (Oracle 8.1 Only) | |
| |
| |
| |
Miscellaneous Packages | |
| |
| |
DBMS_UTILITY: Performing Miscellaneous Operations | |
| |
| |
DBMS_DESCRIBE: Describing PL/SQL Program Headers | |
| |
| |
DBMS_DDL: Compiling and Analyzing Objects | |
| |
| |
DBMS_RANDOM: Generating Random Numbers (Oracle8 Only) | |
| |
| |
| |
Server Management Packages | |
| |
| |
| |
Managing Session Information | |
| |
| |
DBMS_SESSION: Managing Session Information | |
| |
| |
DBMS_SYSTEM: Setting Events for Debugging | |
| |
| |
| |
Managing Server Resources | |
| |
| |
DBMS_SPACE: Obtaining Space Information | |
| |
| |
DBMS_SHARED_POOL: Pinning Objects | |
| |
| |
| |
Job Scheduling in the Database | |
| |
| |
Getting Started with DBMS_ JOB | |
| |
| |
Job Queue Architecture | |
| |
| |
Tips on Using DBMS_JOB | |
| |
| |
DBMS_JOB Examples | |
| |
| |
| |
Distributed Database Packages | |
| |
| |
| |
Snapshots | |
| |
| |
DBMS_SNAPSHOT: Managing Snapshots | |
| |
| |
DBMS_REFRESH: Managing Snapshot Groups | |
| |
| |
DBMS_OFFLINE_SNAPSHOT: Performing Offline Snapshot Instantiation | |
| |
| |
DBMS_REPCAT: Managing Snapshot Replication Groups | |
| |
| |
| |
Advanced Replication | |
| |
| |
DBMS_REPCAT_AUTH: Setting Up Administrative Accounts | |
| |
| |
DBMS_REPCAT_ADMIN: Setting Up More Administrator Accounts | |
| |
| |
DBMS_REPCAT: Replication Environment Administration | |
| |
| |
DBMS_OFFLINE_OG: Performing Site Instantiation | |
| |
| |
DBMS_RECTIFIER_DIFF: Comparing Replicated Tables | |
| |
| |
DBMS_REPUTIL: Enabling and Disabling Replication | |
| |
| |
| |
Conflict Resolution | |
| |
| |
Getting Started with DBMS_REPCAT | |
| |
| |
Column Groups with DBMS_REPCAT | |
| |
| |
Priority Groups with DBMS_REPCAT | |
| |
| |
Site Priority Groups with DBMS_REPCAT | |
| |
| |
Assigning Resolution Methods with DBMS_REPCAT | |
| |
| |
Monitoring Conflict Resolution with DBMS_REPCAT | |
| |
| |
| |
Deferred Transactions and Remote Procedure Calls | |
| |
| |
About Deferred Transactions and RPCs | |
| |
| |
DBMS_DEFER_SYS: Managing Deferred Transactions | |
| |
| |
DBMS_DEFER: Building Deferred Calls | |
| |
| |
DBMS_DEFER_QUERY: Performing Diagnostics and Maintenance A | |
| |
| |
What's on the Companion Disk? | |
| |
| |
Index | |