|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
External LOBs (BFILEs), 12 of 41
"Use Case Model: External LOBs (BFILEs)" for all basic operations of External LOBs (BFILES).
This procedure describes how to INSERT a row containing a BFILE by selecting a BFILE from another table.
With regard to LOBs, one of the advantages of utilizing an object-relational approach is that you can define a type as a common template for related tables. For instance, it makes sense that both the tables that store archival material and the working tables that use those libraries share a common structure. See the following "Scenario".
See the following syntax reference:
The following code fragment is based on the fact that a library table
VoiceoverLib_tab is of the same type (
Voiceover_tab referenced by column
It inserts values from the library table into
Multimedia_tab by means of a
The example is provided in SQL and applies to all programmatic environments: