List of Tables

1-1 SQL Character Data Types
1-2 Binary Floating-Point Format Components
1-3 Summary of Binary Format Storage Parameters
1-4 Range and Precision of Floating-Point Data Types
1-5 Special Values for Native Floating-Point Formats
1-6 Values Resulting from Exceptions
1-7 SQL Datetime Data Types
1-8 SQL Conversion Functions for Datetime Data Types
1-9 Large Objects (LOBs)
1-10 Display Types of SQL Functions
1-11 Data Type Families
2-1 COMMIT Statement Options
2-2 Use of COMMIT, SAVEPOINT, and ROLLBACK
2-3 Examples of Concurrency Under Explicit Locking
2-4 Ways to Display Locking Information
2-5 ANSI/ISO SQL Isolation Levels and Possible Transaction Interactions
2-6 ANSI/ISO SQL Isolation Levels Provided by Oracle Database
2-7 Comparison of READ COMMITTED and SERIALIZABLE Transactions
2-8 Possible Transaction Outcomes
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