List of Examples

1-1 LOCK TABLE with SHARE MODE
1-2 How the Pro*COBOL Precompiler Uses Locks
1-3 Marking a Packaged Subprogram as Autonomous
1-4 Resumable Storage Allocation
2-1 Displaying Current Date and Time with AD or BC Qualifier
2-2 Changing the Default Date Format
2-3 Changing the Default Time Format
2-4 Accessing Information in a SYS.ANYDATA Column
2-5 Querying the ROWID Pseudocolumn
3-1 Enforcing a Phone Number Format with Regular Expressions
3-2 Inserting Phone Numbers in Correct and Incorrect Formats
3-3 Using Back References to Reposition Characters
4-1 VENDOR_PARTS Table
4-2 Creating Indexes
4-3 Function-Based Index Allows Optimizer to Perform Range Scan
4-4 Function-Based Indexes
5-1 Inserting NULL Values into Columns with NOT NULL Constraints
5-2 Deferring Constraint Checks
5-3 Defining Constraints with the CREATE TABLE Statement
5-4 Defining Constraints with the ALTER TABLE Statement
5-5 Creating Enabled Constraints
5-6 Creating Disabled Constraints
5-7 Enabling Existing Constraints
5-8 Disabling Existing Constraints
5-9 Modifying Constraints
5-10 Renaming a Constraint
5-11 Dropping Constraints
5-12 Viewing Information About Constraints
6-1 Anonymous Block
6-2 Anonymous Block with Exception Handler for Predefined Error
6-3 Anonymous Block with Exception Handler for User-Defined Exception
6-4 Stored Procedure with Parameters
6-5 %TYPE and %ROWTYPE Attributes
6-6 Creating PL/SQL Package and Invoking Packaged Subprogram
6-7 Raising ORA-04068
6-8 Trapping ORA-04068
6-9 DML Statements that Reference Collections
6-10 SELECT Statements that Reference Collections
6-11 FOR Loops that Reference Collections and Return DML
6-12 Fetching Data with Cursor Variable
6-13 Cursor Variable with Discriminator
6-14 Compile-Time Errors
6-15 Invoking a Subprogram Interactively with SQL*Plus
6-16 Creating and Using a Session Variable with SQL*Plus
6-17 Invoking a Subprogram from Within Another Subprogram
6-18 PL/SQL Function in SQL Expression (Follows Rules)
6-19 PL/SQL Function in SQL Expression (Exception to Rule)
6-20 PRAGMA RESTRICT_REFERENCES
6-21 PRAGMA RESTRICT REFERENCES with TRUST on Invokee
6-22 PRAGMA RESTRICT REFERENCES with TRUST on Invoker
6-23 Overloaded Packaged Function with PRAGMA RESTRICT_REFERENCES
7-1 Is STANDARD and DBMS_STANDARD PL/Scope Identifier Data Available?
7-2 How Much Space is PL/Scope Data Using?
7-3 USAGE_CONTEXT_ID and USAGE_ID
7-4 Program Unit with Two Identifiers Named p
8-1 Profiling a PL/SQL Procedure
8-2 Invoking DBMS_HPROF.analyze
8-3 DBMSHP_RUNS Table for Sample PL/SQL Procedure
8-4 DBMSHP_FUNCTION_INFO Table for Sample PL/SQL Procedure
8-5 DBMSHP_PARENT_CHILD_INFO Table for Sample PL/SQL Procedure
8-6 Invoking DBMS_HPROF.analyze with Options
9-1 Creating and Configuring DADs
9-2 Authorizing DADs to be Created or Changed Later
9-3 Determining the Authentication Mode for a DAD
9-4 Showing the Authentication Mode for All DADs
9-5 Showing DAD Authorizations that Are Not in Effect
9-6 epgstat.sql Script Output for Example 9-1
9-7 Using HTP Functions to Generate HTML Tags
9-8 Using HTP.PRINT to Generate HTML Tags
9-9 HTML Drop-Down List
9-10 Passing Entry-Field Parameters from an HTML Form
9-11 Sending E-Mail from PL/SQL
9-12 Retrieving HTTP URL Contents from PL/SQL
10-1 simple.psp
10-2 Sample Returned HTML Page
10-3 simplewithuserinput.psp
10-4 Sample Comments in a PSP File
10-5 Loading PL/SQL Server Pages
10-6 Querying PL/SQL Server Page Source Code
10-7 show_prod_simple.psp
10-8 show_catalog_raw.psp
10-9 show_catalog_pretty.psp
10-10 show_product_partial.psp
10-11 show_product_highlighed.psp
10-12 product_form.psp
10-13 show_product_javascript.psp
11-1 Query to be Registered for Change Notification
11-2 Query Too Complex for QRCN in Guaranteed Mode
11-3 Query Whose Simplified Version Invalidates Objects
11-4 Creating a CQ_NOTIFICATION$_REG_INFO Object
11-5 Adding a Query to an Existing Registration
11-6 Creating Server-Side PL/SQL Notification Handler
11-7 Registering a Query
12-1 Retrieving a Lost Row with Oracle Flashback Query
12-2 Restoring a Lost Row After Oracle Flashback Query
12-3 Function that Can Return Row SCN from Table that has VPD
13-1 Pro*C/C++ Application
13-2 Pro*COBOL Application
15-1 xa_open String
15-2 Sample Open String Configuration
15-3 Transaction Started by an Application Server
15-4 Transaction Started by an Application Client
15-5 Using the DBMS_XA Package
18-1 Displaying Dependent and Referenced Object Types
18-2 Schema Object Change that Invalidates Some Dependents
18-3 View that Depends on Multiple Objects
18-4 Changing Body of Procedure get_hire_date
18-5 Changing Data Type Class of get_hire_date Parameter
18-6 Changing Names of Fields in Packaged Record Type
19-1 Inherited and Actual Objects
19-2 Dropping an Inherited Object
19-3 Creating an Object with the Name of a Dropped Inherited Object
19-4 Current Edition Differs from Session Edition
19-5 Crossedition Trigger that Handles Data Transformation Collisions
19-6 Edition-Based Redefinition of Very Simple Procedure
19-7 Creating the Existing Application
19-8 Viewing Data in Existing Table
19-9 Creating an Editioning View for the Existing Table
19-10 Creating Edition in Which to Upgrade the Application
19-11 Changing the Table and Replacing the Editioning View
19-12 Creating and Enabling the Crossedition Triggers
19-13 Applying the Transforms
19-14 Viewing Data in Changed Table
A-1 Setting Configuration Parameters and Starting agtctl