List of Examples

• 1-1 Creating and Using a Table with Valid Time Support
• 1-2 Data Change Using Temporal Validity Support
• 2-1 Setting Session Purity for New Session
• 2-2 Setting the Connection Class as HRMS
• 2-3 Setting the Connection Class as RECMS
• 2-4 Enabling DRCP With :POOLED in Easy Connect String
• 2-5 Enabling DRCP With SERVER=POOLED in TNS Connect String
• 2-6 DRCP Application
• 2-7 Connect String for Deployment in Dedicated Server Mode Without DRCP
• 2-8 Connect String for Deployment With DRCP
• 2-9 Explicitly Marking Sessions Stateful or Stateless
• 3-1 Secure Application Role Procedure to Restrict Access to Business Hours
• 3-2 Creating a Logon Trigger
• 3-3 Creating Program Units with Definer's Rights or Invoker's Rights
• 3-4 Granting a Program Unit Creating the INHERIT PRIVILEGES Privilege
• 3-5 Loading a Java Class with Definer's Rights
• 6-1 LOCK TABLE with SHARE MODE
• 6-2 How the Pro*COBOL Precompiler Uses Locks
• 6-3 Marking a Package Subprogram as Autonomous
• 6-4 AFTER SUSPEND Trigger Handles Suspended Storage Allocation
• 7-1 Performance Comparison of Three Data Types
• 7-2 Displaying Current Date and Time
• 7-3 Inserting and Displaying Dates
• 7-4 Inserting and Displaying Dates and Times
• 7-5 Accessing Information in a SYS.ANYDATA Column
• 7-6 Querying the ROWID Pseudocolumn
• 8-1 Enforcing a Phone Number Format with Regular Expressions
• 8-2 Inserting Phone Numbers in Correct and Incorrect Formats
• 8-3 Using Back References to Reposition Characters
• 9-1 Function-Based Index for Precomputing Arithmetic Expression
• 9-2 Function-Based Indexes on Object Column
• 9-3 Function-Based Index for Faster Case-Insensitive Searches
• 9-4 Function-Based Index for Language-Dependent Sorting
• 10-1 Enforcing Business Rules with Constraints
• 10-2 Enforcing Business Rules with Both Constraints and Application Code
• 10-3 Inserting NULL Values into Columns with NOT NULL Constraints
• 10-4 Deferring Constraint Checks
• 10-5 Defining Constraints with the CREATE TABLE Statement
• 10-6 Defining Constraints with the ALTER TABLE Statement
• 10-7 Creating Enabled Constraints
• 10-8 Creating Disabled Constraints
• 10-9 Enabling Existing Constraints
• 10-10 Disabling Existing Constraints
• 10-11 Modifying Constraints
• 10-12 Renaming a Constraint
• 10-13 Dropping Constraints
• 10-14 Viewing Information About Constraints
• 11-1 Changing PLSQL_OPTIMIZE_LEVEL
• 11-2 Parsing Penalty for Cursor Variable
• 11-3 Array Fetching Penalty for Cursor Variable
• 11-4 DML Statements that Reference Collections
• 11-5 SELECT Statements that Reference Collections
• 11-6 FOR Loops that Reference Collections and Return DML
• 11-7 Invoking a Subprogram Interactively with SQL*Plus
• 11-8 Creating and Using a Session Variable with SQL*Plus
• 11-9 Invoking a Subprogram from Within Another Subprogram
• 11-10 PL/SQL Function in SQL Expression (Follows Rules)
• 11-11 PRAGMA RESTRICT_REFERENCES
• 11-12 PRAGMA RESTRICT REFERENCES with TRUST on Invoker
• 11-13 PRAGMA RESTRICT REFERENCES with TRUST on Invokee
• 11-14 Raising ORA-04068
• 11-15 Trapping ORA-04068
• 12-1 STANDARD and DBMS_STANDARD PL/Scope Identifier Data Available?
• 12-2 How Much Space is PL/Scope Data Using?
• 12-3 USAGE_CONTEXT_ID and USAGE_ID
• 12-4 Program Unit with Two Identifiers Named p
• 13-1 Profiling a PL/SQL Procedure
• 13-2 Invoking DBMS_HPROF.analyze
• 13-3 DBMSHP_RUNS Table for Sample PL/SQL Procedure
• 13-4 DBMSHP_FUNCTION_INFO Table for Sample PL/SQL Procedure
• 13-5 DBMSHP_PARENT_CHILD_INFO Table for Sample PL/SQL Procedure
• 13-6 Invoking DBMS_HPROF.analyze with Options
• 14-1 Creating and Configuring DADs
• 14-2 Authorizing DADs to be Created or Changed Later
• 14-3 Determining the Authentication Mode for a DAD
• 14-4 Showing the Authentication Mode for All DADs
• 14-5 Showing DAD Authorizations that Are Not in Effect
• 14-6 epgstat.sql Script Output for Example 14-1
• 14-7 Using HTP Functions to Generate HTML Tags
• 14-8 Using HTP.PRINT to Generate HTML Tags
• 14-9 HTML Drop-Down List
• 14-10 Passing Entry-Field Parameters from an HTML Form
• 14-11 Sending E-Mail from PL/SQL
• 14-12 Retrieving HTTP URL Contents from PL/SQL
• 15-1 Query to be Registered for Change Notification
• 15-2 Query Too Complex for QRCN in Guaranteed Mode
• 15-3 Query Whose Simplified Version Invalidates Objects
• 15-4 Creating a CQ_NOTIFICATION$_REG_INFO Object
• 15-5 Adding a Query to an Existing Registration
• 15-6 Creating Server-Side PL/SQL Notification Handler
• 15-7 Registering a Query
• 15-8 Program Listing That Demonstrates Continuous Query Notification
• 16-1 Retrieving a Lost Row with Oracle Flashback Query
• 16-2 Restoring a Lost Row After Oracle Flashback Query
• 17-1 Pro*C/C++ Application
• 17-2 Pro*COBOL Application
• 19-1 xa_open String
• 19-2 Sample Open String Configuration
• 19-3 Transaction Started by an Application Server
• 19-4 Transaction Started by an Application Client
• 19-5 Using the DBMS_XA Package
• 23-1 Displaying Dependent and Referenced Object Types
• 23-2 Schema Object Change that Invalidates Some Dependents
• 23-3 View that Depends on Multiple Objects
• 23-4 Changing Body of Procedure get_hire_date
• 23-5 Changing Data Type Class of get_hire_date Parameter
• 23-6 Changing Names of Fields in Package Record Type
• 24-1 Editioned Objects and Copy-on-Change
• 24-2 Dropping an Editioned Object
• 24-3 Creating an Object with the Name of a Dropped Inherited Object
• 24-4 Current Edition Differs from Session Edition
• 24-5 Crossedition Trigger that Handles Data Transformation Collisions
• 24-6 EBR of Very Simple Procedure
• 24-7 Creating the Existing Application
• 24-8 Viewing Data in Existing Table
• 24-9 Creating an Editioning View for the Existing Table
• 24-10 Creating Edition in Which to Upgrade the Application
• 24-11 Changing the Table and Replacing the Editioning View
• 24-12 Creating and Enabling the Crossedition Triggers
• 24-13 Applying the Transforms
• 24-14 Viewing Data in Changed Table
• 25-1 Adding and Modifying a Service for a Server Pool
• 25-2 Adding an Administrator-Managed Service
• 25-3 Modifying a Service (PL/SQL)