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 Add a New Column of Type ORDImage to the emp Table

2-13 Add ORDImage Types to a New Table

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

2-15 Populate a Row with ORDImage BLOB Data

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

2-17 Populate a Row with ORDImage External File Data

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

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

2-20 Import an Image from an External File

2-21 Copy an Image

2-22 Convert an Image Format

2-23 Copy and Convert an Image Format

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

2-25 Create an Object View on a Flat Table

2-26 Address a National Language Support Issue

2-27 Define a Clip Object

2-28 Create a Table Named clipsTable

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

2-30 Define the Implementation of the clipList Object

2-31 Create a Video Table Containing Video Information

2-32 Insert a Video Clip into the clipsTable Table

2-33 Insert a Row into the videoTable Table

2-34 Load a Video into the clipsTable Table

2-35 Insert a Reference to a Clip Object into the Clips List in the videoTable Table

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

2-37 Retrieve a Video Clip

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

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

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

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

7-2 Show the Load1.bat File

7-3 Show the T1.SQL File

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

7-5 Show the Control File for Loading Video Data

7-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

---