LOB "Demo" Directory

LOB demonstration sample scripts are currently provided in this manual in Chapters 9, 10, and 11 primarily. The vast majority of these scripts have been tested and run successfully. The syntax for the sample multimedia schema described in Chapter 8, is provided in:

• Chapter 9, "Internal Persistent LOBs", under "CREATE a Table Containing One or More LOB Columns" on

• Chapter 10, "Temporary LOBs", under "Create a Temporary LOB"

• Chapter 11, "External LOBs (BFILEs)", under Chapter , "CREATE a Table Containing One or More BFILE Columns"

The SQL set up syntax for the above schema is also provided in the Oracle8i "demo" directory in the following files:

• lobdemo.sql

• adloci.sql.

Location of Demo Directories?

Demonstration scripts are available with your Oracle8i installation. The location, names, and availability of the programs may vary on different platforms. See your platform specific documentation. For UNIX and Windows NT

• Unix: On a Unix workstation, the programs are installed in the ORACLE_HOME/rdbms/demo directory.

• Windows NT: On a WindowsNT machine, the programs are located in the ORACLE_HOME\Oci\Samples directory, for example, for OCI code examples.