2/31

List of Examples

• 1-1 Displaying Current Date and Time in Nondefault Format
• 1-2 Inserting and Displaying Date in Nondefault Formats
• 1-3 Inserting and Displaying Dates and Times in Nondefault Formats
• 1-4 Accessing Information in a SYS.ANYDATA Column
• 1-5 Querying the ROWID Pseudocolumn
• 2-1 LOCK TABLE with SHARE MODE
• 2-2 How the Pro*COBOL Precompiler Uses Locks
• 2-3 Marking a Package Subprogram as Autonomous
• 2-4 AFTER SUSPEND Trigger Handles Suspended Storage Allocation
• 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 Function-Based Index for Precomputing Arithmetic Expression
• 4-2 Function-Based Indexes on Object Column
• 4-3 Function-Based Index for Faster Case-Insensitive Searches
• 4-4 Function-Based Index for Language-Dependent Sorting
• 5-1 Enforcing Business Rules with Constraints
• 5-2 Enforcing Business Rules with Both Constraints and Application Code
• 5-3 Inserting NULL Values into Columns with NOT NULL Constraints
• 5-4 Deferring Constraint Checks
• 5-5 Defining Constraints with the CREATE TABLE Statement
• 5-6 Defining Constraints with the ALTER TABLE Statement
• 5-7 Creating Enabled Constraints
• 5-8 Creating Disabled Constraints
• 5-9 Enabling Existing Constraints
• 5-10 Disabling Existing Constraints
• 5-11 Modifying Constraints
• 5-12 Renaming a Constraint
• 5-13 Dropping Constraints
• 5-14 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 Package 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 Package 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 Email 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
• 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 Package 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