List of Examples

2-1 Define a Song Object

2-2 Create a Table Named SongsTable

2-3 Create a List Object Containing a List of References to Songs

2-4 Define the Implementation of the songList Object

2-5 Create a CD Table Containing CD Information

2-6 Insert a Song into the SongsTable Table

2-7 Insert a CD into the CdTable Table

2-8 Load a Song into the SongsTable Table

2-9 Insert a Reference to a Song Object into the Songs List in the CdTable Table

2-10 Add a CD Reference to a Song

2-11 Retrieve Audio Data from a Song in a CD

2-12 Define a Relational Table Containing No ORDAudio Object

2-13 Define an Object View Containing an ORDAudio Object and Relational Columns

2-14 Add a New Column of Type ORDImage to the emp Table

2-15 Add ORDImage Types to a New Table

2-16 Insert a Row into a Table with Empty Data in the ORDImage Type Column

2-17 Populate a Row with ORDImage BLOB Data

2-18 Insert a Row into a Table with an Image in the ORDImage Type Column

2-19 Populate a Row with ORDImage External File Data

2-20 Query Rows of ORDImage Data for Widths Greater Than 32

2-21 Query Rows of ORDImage Data for Widths Greater Than 32 and a Minimum Content Length

2-22 Import an Image from an External File

2-23 Copy an Image

2-24 Convert an Image Format

2-25 Copy and Convert an Image Format

2-26 Extend Oracle interMedia Image with a New Object Type

2-27 Define a Relational Table Containing No ORDImage Object

2-28 Define an Object View Containing an ORDImage Object and Relational Columns

2-29 Address a National Language Support Issue

2-30 Define a Clip Object

2-31 Create a Table Named ClipsTable

2-32 Create a List Object Containing a List of Clips

2-33 Define the Implementation of the clipList Object

2-34 Create a Video Table Containing Video Information

2-35 Insert a Video Clip into the clipsTable Table

2-36 Insert a Row into the VideoTable Table

2-37 Load a Video into the ClipsTable Table

2-38 Insert a Reference to a Clip Object into the Clips List in the VideoTable Table

2-39 Insert a Reference to a Video Object into the Clip

2-40 Retrieve a Video Clip

2-41 Define a Relational Table Containing No ORDVideo Object

2-42 Define an Object View Containing an ORDVideo Object and Relational Columns

4-1 Show the Package Body for Extending Support to a New Audio
Data Format

6-1 Show the Package Body for Extending Support to a New Video
Data Format

7-1 Show the Package Body for Extending Support to a New Data Source

8-1 Create a Separate Tablespace to Store an interMedia Column Object Containing LOB Data

8-2 Show the Load1.bat File

8-3 Show the T1.SQL File

8-4 Show the Load1.sql File that Executes the load_image Stored Procedure

8-5 Show the Control File for Loading Video Data

8-6 Read Data from an ORDVideo Column Object Using interMedia readFromSource( ) Method in a PL/SQL Stored Procedure

F-1 Execute the Demo from the Command Line