- Oracle Built-in Packages
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
- Dedication
- Preface
- I. Overview
- 1. Introduction
- The Power of Built-in Packages
- Built-in Packages Covered in This Book
- Using Built-in Packages
- Examining Built-in Package Source Code
- 1. Introduction
- II. Application Development Packages
- 2. Executing Dynamic SQL and PL/SQL
- The DBMS_SQL Interface
- Tips on Using Dynamic SQL
- DBMS_SQL Examples
- 3. Intersession Communication
- DBMS_PIPE: Communicating Between Sessions
- Getting Started with DBMS_PIPE
- How Database Pipes Work
- Managing Pipes and the Message Buffer
- Packing and Unpacking Messages
- Sending and Receiving Messages
- Tips on Using DBMS_PIPE
- DBMS_PIPE Examples
- DBMS_ALERT: Broadcasting Alerts to Users
- Getting Started with DBMS_ALERT
- The DBMS_ALERT Interface
- DBMS_ALERT Examples
- DBMS_PIPE: Communicating Between Sessions
- 4. User Lock and Transaction Management
- DBMS_LOCK: Creating and Managing Resource Locks
- DBMS_TRANSACTION: Interfacing to SQL Transaction Statements
- 5. 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
- 6. Generating Output from PL/SQL Programs
- DBMS_OUTPUT: Displaying Output
- UTL_FILE: Reading and Writing Server-side Files
- 7. Defining an Application Profile
- Getting Started with DBMS_APPLICATION_INFO
- DBMS_APPLICATION_INFO Interface
- The DBMS_APPLICATION_INFO.READ_CLIENT_INFO procedure
- The DBMS_APPLICATION_INFO.READ_MODULE procedure
- The DBMS_APPLICATION_INFO.SET_ACTION procedure
- The DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure
- The DBMS_APPLICATION_INFO.SET_MODULE procedure
- The DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure
- DBMS_APPLICATION_INFO Examples
- 8. Managing Large Objects
- Getting Started with DBMS_LOB
- LOB Concepts
- DBMS_LOB Interface
- Working with BFILEs
- Reading and Examining LOBs
- Updating BLOBs, CLOBs, and NCLOBs
- The DBMS_LOB.APPEND procedure
- The DBMS_LOB.COPY procedure
- The DBMS_LOB.ERASE procedure
- The DBMS_LOB.TRIM procedure
- The DBMS_LOB.WRITE procedure
- Exceptions
- Example
- 9. Datatype Packages
- DBMS_ROWID: Working with the ROWID Pseudo-Column (Oracle8 only)
- Getting Started with DBMS_ROWID
- ROWID Concepts
- The DBMS_ROWID Interface
- The DBMS_ROWID.ROWID_BLOCK_NUMBER function
- The DBMS_ROWID.CREATE_ROWID function
- The DBMS_ROWID.ROWID_INFO procedure
- The DBMS_ROWID.ROWID_OBJECT function
- The DBMS_ROWID.ROWID_RELATIVE_FNO function
- The DBMS_ROWID.ROWID_ROW_NUMBER function
- The DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO function
- The DBMS_ROWID.ROWID_TO_EXTENDED function
- The DBMS_ROWID.ROWID_TO_RESTRICTED function
- The DBMS_ROWID.ROWID_TYPE function
- The DBMS_ROWID. ROWID_VERIFY function
- UTL_RAW: Manipulating Raw Data
- Getting Started with UTL_RAW
- Raw Data Manipulation Concepts
- The UTL_RAW Interface
- The UTL_RAW.BIT_AND function
- The UTL_RAW.BIT_COMPLEMENT function
- The UTL_RAW.BIT_OR function
- The UTL_RAW.BIT_XOR function
- The UTL_RAW.CAST_TO_RAW function
- The UTL_RAW.CAST_TO_VARCHAR2 function
- The UTL_RAW. COMPARE function
- The UTL_RAW.CONCAT function
- The UTL_RAW.CONVERT function
- The UTL_RAW.COPIES function
- The UTL_RAW.LENGTH function
- The UTL_RAW.OVERLAY function
- The UTL_RAW.REVERSE function
- The UTL_RAW.SUBSTR function
- The UTL_RAW.TRANSLATE function
- The UTL_RAW.TRANSLITERATE function
- The UTL_RAW.XRANGE function
- UTL_REF: Referencing Objects (Oracle8.0.4)
- DBMS_ROWID: Working with the ROWID Pseudo-Column (Oracle8 only)
- 10. Miscellaneous Packages
- DBMS_UTILITY: Performing Miscellaneous Operations
- Getting Started with DBMS_UTILITY
- The DBMS_UTILITY Interface
- The DBMS_UTILITY.ANALYZE_DATABASE procedure
- The DBMS_UTILITY. ANALYZE_SCHEMA procedure
- The DBMS_UTILITY. ANALYZE_PART_OBJECT procedure (Oracle8 Only)
- The DBMS_UTILITY.COMMA_TO_TABLE procedure
- The DBMS_UTILITY. COMPILE_SCHEMA procedure
- The DBMS_UTILITY. DATA_BLOCK_ADDRESS_BLOCK function
- The DBMS_UTILITY. DATA_BLOCK_ADDRESS_FILE function
- The DBMS_UTILITY. DB_VERSION procedure
- The DBMS_UTILITY. EXEC_DDL_STATEMENT procedure
- The DBMS_UTILITY. FORMAT_CALL_STACK function
- The DBMS_UTILITY.FORMAT_ERROR_STACK function
- The DBMS_UTILITY. GET_HASH_VALUE function
- The DBMS_UTILITY. GET_PARAMETER_VALUE function
- The DBMS_UTILITY. GET_TIME function
- The DBMS_UTILITY. IS_PARALLEL_SERVER function
- The DBMS_UTILITY. MAKE_DATA_BLOCK_ADDRESS function
- The DBMS_UTILITY. NAME_RESOLVE procedure
- The DBMS_UTILITY.NAME_TOKENIZE procedure
- The DBMS_UTILITY.PORT_STRING function
- The DBMS_UTILITY.TABLE_TO_COMMA procedure
- DBMS_DESCRIBE: Describing PL/SQL Program Headers
- DBMS_DDL: Compiling and Analyzing Objects
- DBMS_RANDOM: Generating Random Numbers (Oracle8 Only)
- Getting Started with DBMS_RANDOM
- DBMS_RANDOM Interface
- The DBMS_RANDOM.INITIALIZE procedure
- The DBMS_RANDOM.SEED procedure (Oracle8 only)
- The DBMS_RANDOM.RANDOM function (Oracle8 only)
- The DBMS_RANDOM.TERMINATE procedure (Oracle8 only)
- III. Server Management Packages
- 11. Managing Session Information
- DBMS_SESSION: Managing Session Information
- Getting Started with DBMS_SESSION
- Modifying Session Settings
- Obtaining Session Information
- Managing Session Resources
- DBMS_SESSION Examples
- DBMS_SYSTEM: Setting Events for Debugging
- DBMS_SESSION: Managing Session Information
- 12. Managing Server Resources
- 13. Job Scheduling in the Database
- Getting Started with DBMS_ JOB
- Job Queue Architecture
- Tips on Using DBMS_JOB
- DBMS_JOB Examples
- 11. Managing Session Information
- IV. Distributed Database Packages
- 14. Snapshots
- DBMS_SNAPSHOT: Managing Snapshots
- DBMS_REFRESH: Managing Snapshot Groups
- 14. Snapshots
- DBMS_REPCAT: Managing Snapshot Replication Groups
- Getting Started with DBMS_REPCAT
- Creating and Dropping Snapshot Replication Groups
- Adding and Removing Snapshot Replication Group Objects
- Altering a Snapshot Replication Group’s Propagation Mode
- Manually Refreshing a Snapshot Replication Group
- Switching the Master of a Snapshot Replication Group
- The DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER procedure
- Exceptions
- Restrictions
- Example
- 15. Advanced Replication
- DBMS_REPCAT_AUTH: Setting Up Administrative Accounts
- DBMS_REPCAT_ADMIN: Setting Up More Administrator Accounts
- DBMS_REPCAT: Replication Environment Administration
- Getting Started with DBMS_REPCAT
- Replication Groups with DBMS_REPCAT
- Replicated Objects with DBMS_REPCAT
- Replication Support with DBMS_REPCAT
- Adding and Removing Master Sites with DBMS_REPCAT
- Maintaining the Repcatlog Queue with DBMS_REPCAT
- Quiescence with DBMS_REPCAT
- Miscellaneous DBMS_REPCAT Procedures
- DBMS_OFFLINE_OG: Performing Site Instantiation
- DBMS_RECTIFIER_DIFF: Comparing Replicated Tables
- DBMS_REPUTIL: Enabling and Disabling Replication
- 16. Conflict Resolution
- Getting Started with DBMS_REPCAT
- Column Groups with DBMS_REPCAT
- Priority Groups with DBMS_REPCAT
- About Priority Groups
- Creating, Maintaining, and Dropping Priority Groups
- Creating and Maintaining Priorities Within a Priority Group
- Dropping Priorities from a Priority Group
- Site Priority Groups with DBMS_REPCAT
- Assigning Resolution Methods with DBMS_REPCAT
- Monitoring Conflict Resolution with DBMS_REPCAT
- About Monitoring
- The DBMS_REPCAT.REGISTER_STATISTICS procedure
- The DBMS_REPCAT.CANCEL_STATISTICS procedure
- The DBMS_REPCAT.PURGE_STATISTICS procedure
- Exceptions
- Example
- 17. Deferred Transactions and Remote Procedure Calls
- About Deferred Transactions and RPCs
- DBMS_DEFER_SYS: Managing Deferred Transactions
- Getting Started with DBMS_DEFER_SYS
- Adding and Deleting Default Destinations
- Copying Deferred Transactions to New Destinations
- Maintenance Procedures
- Propagating Deferred RPCs
- Scheduling Propagation (Oracle8 only)
- The DBMS_DEFER_SYS.EXCLUDE_PUSH function (Oracle8 only)
- The DBMS_DEFER_SYS.PURGE function (Oracle8 only)
- The DBMS_DEFER_SYS.PUSH function
- The DBMS_DEFER_SYS.SCHEDULE_PURGE procedure (Oracle8 only)
- The DBMS_DEFER_SYS.SCHEDULE_PUSH procedure (Oracle8 only)
- The DBMS_DEFER_SYS.UNSCHEDULE_PURGE procedure (Oracle8 only)
- The DBMS_DEFER_SYS.UNSCHEDULE_PUSH procedure (Oracle8 only)
- The DBMS_DEFER_SYS.REGISTER_PROPAGATOR procedure (Oracle8 only)
- The DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR procedure (Oracle8 only)
- DBMS_DEFER: Building Deferred Calls
- DBMS_DEFER_QUERY: Performing Diagnostics and Maintenance
- About Monitoring
- The DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER procedure
- DBMS_UTILITY: Performing Miscellaneous Operations
A note on the digital index
A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.
Symbols
- % (multiple-character substitution), Wildcarded correlation identifiers
- <datatype>_ARG procedure (DBMS_DEFER), DBMS_DEFER programs, The DBMS_DEFER. <datatype>_ARG procedure, Example
- => (named notation), Example
- [ and ] (optional parameters), The DBMS_SQL.BIND_VARIABLE procedure
- _ (single-character substitution), Wildcarded correlation identifiers
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.