List of Tables

• 3-1 Table Annotation Result Cache Modes
• 3-2 Effective Result Cache Table Mode
• 3-3 Client Configuration Parameters (Optional)
• 3-4 Setting Client Result Cache and Server Result Cache
• 3-5 Session Purity and Connection Class Defaults
• 8-1 COMMIT Statement Options
• 8-2 Examples of Concurrency Under Explicit Locking
• 8-3 Ways to Display Locking Information
• 8-4 ANSI/ISO SQL Isolation Levels and Possible Transaction Interactions
• 8-5 ANSI/ISO SQL Isolation Levels Provided by Oracle Database
• 8-6 Comparison of READ COMMITTED and SERIALIZABLE Transactions
• 8-7 Possible Transaction Outcomes
• 9-1 SQL Character Data Types
• 9-2 Range and Precision of Floating-Point Data Types
• 9-3 Binary Floating-Point Format Components
• 9-4 Summary of Binary Format Storage Parameters
• 9-5 Special Values for Native Floating-Point Formats
• 9-6 Values Resulting from Exceptions
• 9-7 SQL Datetime Data Types
• 9-8 SQL Conversion Functions for Datetime Data Types
• 9-9 Large Objects (LOBs)
• 9-10 Display Types of SQL Functions
• 9-11 SQL Data Type Families
• 10-1 Oracle SQL Pattern-Matching Condition and Functions
• 10-2 Oracle SQL Pattern-Matching Options for Condition and Functions
• 10-3 POSIX Operators in Oracle SQL Regular Expressions
• 10-4 POSIX Operators and Multilingual Operator Relationships
• 10-5 PERL-Influenced Operators in Oracle SQL Regular Expressions
• 10-6 Explanation of the Regular Expression Elements
• 10-7 Explanation of the Regular Expression Elements
• 14-1 Identifier Types that PL/Scope Collects
• 14-2 Usages that PL/Scope Reports
• 15-1 Raw Profiler Output File Indicators
• 15-2 Function Names of Operations that the PL/SQL Hierarchical Profiler Tracks
• 15-3 PL/SQL Hierarchical Profiler Database Tables
• 15-4 DBMSHP_RUNS Table Columns
• 15-5 DBMSHP_FUNCTION_INFO Table Columns
• 15-6 DBMSHP_PARENT_CHILD_INFO Table Columns
• 16-1 DBMSPCC_RUNS Table Columns
• 16-2 DBMSPCC_UNITS Table Columns
• 16-3 DBMSPCC_BLOCKS Table Columns
• 17-1 Commonly Used Packages in the PL/SQL Web Toolkit
• 17-2 Mapping Between mod_plsql and Embedded PL/SQL Gateway DAD Attributes
• 17-3 Mapping Between mod_plsql and Embedded PL/SQL Gateway Global Attributes
• 17-4 Authentication Possibilities for a DAD
• 18-1 Continuous Query Notification Registration Options
• 18-2 Attributes of CQ_NOTIFICATION$_REG_INFO
• 18-3 Quality-of-Service Flags
• 18-4 Attributes of CQ_NOTIFICATION$_DESCRIPTOR
• 18-5 Attributes of CQ_NOTIFICATION$_TABLE
• 18-6 Attributes of CQ_NOTIFICATION$_QUERY
• 18-7 Attributes of CQ_NOTIFICATION$_ROW
• 19-1 Oracle Flashback Version Query Row Data Pseudocolumns
• 19-2 Flashback TRANSACTION_BACKOUT Options
• 19-3 Static Data Dictionary Views for Flashback Data Archive Files
• 20-1 PL/SQL Packages and Their Java Equivalents
• 21-1 Parameter Data Type Mappings
• 21-2 External Data Type Mappings
• 21-3 Properties and Data Types
• 22-1 Required XA Features Published by Oracle Database
• 22-2 XA Library Subprograms
• 22-3 Oracle XA Interface Extensions
• 22-4 Required Fields of xa_open string
• 22-5 Optional Fields in the xa_open String
• 22-6 TX Interface Functions
• 22-7 TPM Replacement Statements
• 22-8 Sample Trace File Contents
• 22-9 Tightly and Loosely Coupled Transaction Branches
• 24-1 Files Installed by the Oracle ODBC Driver Kit
• 24-2 Oracle ODBC Driver and Oracle Database Limitations on Data Types
• 24-3 Error Message Values of Prefixes Returned by the Oracle ODBC Driver
• 24-4 Keywords that Can Be Included in the Connection String Argument of the SQLDriverConnect Function Call
• 24-5 Keywords Required by the SQLDriverConnect Connection String
• 24-6 How Oracle ODBC Driver Implements Specific Functions
• 24-7 Supported SQL Data Types and the Equivalent ODBC SQL Data Type
• 25-1 General Structure of EPC Encodings
• 25-2 Identity Code Package ADTs
• 25-3 MGD_ID ADT Subprograms
• 25-4 DBMS_MGD_ID_UTL Package Utility Subprograms
• 25-5 Definition and Description of the MGD_ID_CATEGORY Metadata View
• 25-6 Definition and Description of the USER_MGD_ID_CATEGORY Metadata View
• 25-7 Definition and Description of the MGD_ID_SCHEME Metadata View
• 25-8 Definition and Description of the USER_MGD_ID_SCHEME Metadata View
• 26-1 Database Object Status
• 26-2 Operations that Cause Fine-Grained Invalidation
• 26-3 Data Type Classes
• 27-1 *_ Dictionary Views with Edition Information
• 27-2 *_ Dictionary Views with Editioning View Information
• 28-1 LTXID Condition or Situation, Application Actions, and Next LTXID to Use
• 28-2 Transaction Manager Conditions/ Situations and Actions