List of Tables

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