List of Examples

1-1 Simple PL/SQL Example

3-1 Components of a Floating-Point Number

3-2 Components of a Floating-Point Number in Binary Format

3-3 Indicating Time with the TO_DATE Function

3-4 Accessing Information in a SYS.ANYDATA Column

3-5 Sample Output for Example 3-4

4-1 Enforcing a Phone Number Format with Regular Expressions

4-2 insert_contacts.sql

4-3 Using Back References to Reposition Characters

4-4 Using Back References to Reposition Characters

4-5 Result Set of Regular Expression Query

8-1 Using SELECT . . . TABLE in Dynamic SQL

8-2 Dynamically Specifying a Table Name

8-3 Concatenating Hints

8-4 Event Dispatching with Static SQL

8-5 Event Dispatching with Native Dynamic SQL

8-6 Performing DML in Native Dynamic SQL

8-7 Dropping a Table with Native Dynamic SQL

8-8 Performing Single-Row Queries in Native Dynamic SQL

8-9 Performing Multiple-Row Queries with Dynamic SQL

8-10 Using Native Dynamic SQL Without Bind Variables

8-11 Using Native Dynamic SQL with Bind Variables

8-12 Using Native Dynamic SQL to Fetch into Records

8-13 Setup for Injection Examples

8-14 ckpwd Procedure

8-15 Authenticating a User with the ckpwd Procedure

8-16 Password String Entered in Form

8-17 Performing Statement Modification with the ckpwd Procedure

8-18 call_ckpwd Procedure

8-19 Authenticating a User with the call_ckpwd Procedure

8-20 Bogus Password Entered in Form

8-21 Performing Statement Injection with the call_ckpwd Procedure

8-22 ckpwd_bind Procedure

8-23 Preventing Statement Modification with the ckpwd_bind Procedure

10-1 Retrieving a Row with Flashback Query

10-2 Reinserting a Row After a Flashback Query

11-1 Displaying HTML Tags with HTP Functions

11-2 Displaying HTML Tags with HTP.PRINT

11-3 HTML Drop-Down List

12-1 simple.psp

12-2 Sample Returned HTML Page

12-3 Sample Comments in a PSP File

12-4 Loading a PSP

12-5 Output from Query of USER_SOURCE

12-6 show_prod_simple.psp

12-7 show_catalog_raw.psp

12-8 show_catalog_pretty.psp

12-9 show_product_partial.psp

12-10 show_product_highlighed.psp

12-11 product_form.psp

12-12 show_product_javascript.psp

13-1 Creating a CHNF$_REG_INFO Object

13-2 Registering the Employees Table for Change Notifications

13-3 Adding an Object to an Existing Registration

13-4 Server-Side PL/SQL Callback Procedure

13-5 Table Registration

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