List of Tables

• 1-1 COMMIT Statement Options
• 1-2 Use of COMMIT, SAVEPOINT, and ROLLBACK
• 1-3 Examples of Concurrency Under Explicit Locking
• 1-4 Ways to Display Locking Information
• 1-5 Summary of ANSI Isolation Levels
• 1-6 ANSI Isolation Levels and Oracle Database
• 1-7 Read Committed and Serializable Transactions
• 1-8 Possible Transaction Outcomes
• 2-1 Components of the Binary Format for Floating-Point Numbers
• 2-2 Summary of Binary Format Parameters
• 2-3 Summary of Binary Format Storage Parameters
• 2-4 Range and Precision of IEEE 754 formats
• 2-5 Special Values for Native Floating-Point Formats
• 2-6 Values Resulting from Exceptions
• 2-7 Large Object Data Types
• 2-8 ANSI Data Type Conversions to Oracle Database Data Types
• 2-9 SQL/DS, DB2 Data Type Conversions to Oracle Database Data Types
• 2-10 Data Type Families
• 2-11 Display Types of SQL Built-In Functions
• 3-1 SQL Regular Expression Functions and Conditions
• 3-2 POSIX Metacharacters in Oracle Database Regular Expressions
• 3-3 POSIX and Multilingual Operator Relationships
• 3-4 PERL-Influenced Extensions in Oracle Database Regular Expressions
• 3-5 Pattern Matching Modifiers
• 3-6 Explanation of the Regular Expression Elements in Example 3-1
• 3-7 Explanation of the Regular Expression Elements in Example 3-3
• 6-1 Attributes of Subprogram Parameters
• 6-2 Parameter Modes
• 7-1 Identifier Types that PL/Scope Collects
• 7-2 Usages that PL/Scope Reports
• 8-1 Raw Profiler Output File Indicators
• 8-2 Function Names of Operations that the PL/SQL Hierarchical Profiler Tracks
• 8-3 PL/SQL Hierarchical Profiler Database Tables
• 8-4 DBMSHP_RUNS Table Columns
• 8-5 DBMSHP_FUNCTION_INFO Table Columns
• 8-6 DBMSHP_PARENT_CHILD_INFO Table Columns
• 9-1 Commonly Used Packages in the PL/SQL Web Toolkit
• 9-2 Mapping Between mod_plsql and Embedded PL/SQL Gateway DAD Attributes
• 9-3 Mapping Between mod_plsql and Embedded PL/SQL Gateway Global Attributes
• 9-4 Authentication Possibilities for a DAD
• 10-1 PSP Elements
• 11-1 Continuous Query Notification Registration Options
• 11-2 Attributes of CQ_NOTIFICATION$_REG_INFO
• 11-3 Quality-of-Service Flags
• 11-4 Attributes of CQ_NOTIFICATION$_DESCRIPTOR
• 11-5 Attributes of CQ_NOTIFICATION$_TABLE
• 11-6 Attributes of CQ_NOTIFICATION$_QUERY
• 11-7 Attributes of CQ_NOTIFICATION$_ROW
• 12-1 Oracle Flashback Version Query Row Data Pseudocolumns
• 12-2 Flashback TRANSACTION_BACKOUT Options
• 12-3 Static Data Dictionary Views for Flashback Data Archive Files
• 13-1 PL/SQL Packages and Their Java Equivalents
• 14-1 Parameter Data Type Mappings
• 14-2 External Data Type Mappings
• 14-3 Properties and Data Types
• 15-1 Required XA Features Published by Oracle Database
• 15-2 XA Library Subprograms
• 15-3 Oracle XA Interface Extensions
• 15-4 Required Fields of xa_open string
• 15-5 Optional Fields in the xa_open String
• 15-6 TX Interface Functions
• 15-7 TPM Replacement Statements
• 15-8 Sample Trace File Contents
• 15-9 Tightly and Loosely Coupled Transaction Branches
• 17-1 General Structure of EPC Encodings
• 17-2 Identity Code Package ADTs
• 17-3 MGD_ID ADT Subprograms
• 17-4 DBMS_MGD_ID_UTL Package Utility Subprograms
• 17-5 Definition and Description of the MGD_ID_CATEGORY Metadata View
• 17-6 Definition and Description of the USER_MGD_ID_CATEGORY Metadata View
• 17-7 Definition and Description of the MGD_ID_SCHEME Metadata View
• 17-8 Definition and Description of the USER_MGD_ID_SCHEME Metadata View
• 18-1 Database Object Status
• 18-2 Operations that Cause Fine-Grained Invalidation
• 18-3 Data Type Classes
• 19-1 *_ Dictionary Views with Edition Information
• 19-2 *_ Dictionary Views with Editioning View Information
• A-1 Agent Control Utility (agtctl) Commands
• A-2 Configuration Parameters for agtctl