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 ANSI/ISO SQL Isolation Levels and Possible Transaction Interactions
• 1-6 ANSI/ISO SQL Isolation Levels Provided by Oracle Database
• 1-7 Comparison of READ COMMITTED and SERIALIZABLE Transactions
• 1-8 Possible Transaction Outcomes
• 2-1 SQL Character Data Types
• 2-2 Binary Floating-Point Format Components
• 2-3 Summary of Binary Format Storage Parameters
• 2-4 Range and Precision of Floating-Point Data Types
• 2-5 Special Values for Native Floating-Point Formats
• 2-6 Values Resulting from Exceptions
• 2-7 SQL Datetime Data Types
• 2-8 SQL Conversion Functions for Datetime Data Types
• 2-9 Large Objects (LOBs)
• 2-10 Display Types of SQL Functions
• 2-11 Data Type Families
• 3-1 Oracle SQL Pattern-Matching Condition and Functions
• 3-2 Pattern-Matching Options for Oracle SQL Pattern-Matching Condition and Functions
• 3-3 POSIX Operators in Oracle SQL Regular Expressions
• 3-4 POSIX Operators and Multilingual Operator Relationships
• 3-5 PERL-Influenced Operators in Oracle SQL Regular Expressions
• 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
• 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