|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
Internal Persistent LOBs, 9 of 43
"Use Case Model: Internal Persistent LOBs Operations", for all Internal Persistent LOB operations.
This procedure describes how to insert a row containing a LOB as SELECT.
For example, assuming
VoiceoverLib_tab have identical schemas. The statement creates a new
LOB locator in table
Voiceover_tab. It also copies the
LOB data from
VoiceoverLib_tab to the location pointed to by the new
LOB locator inserted in table
Use the following syntax reference:
For LOBs, one of the advantages of using 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 working tables that use those libraries, share a common structure.
The following code fragment is based on the fact that a library table
VoiceoverLib_tab is of the same type (
Voiceover_tab referenced by the
Voiced_ref column of table
Multimedia_tab. It inserts values into the library table, and then inserts this same data into
Multimedia_tab by means of a
Appendix B, "The Multimedia Schema Used for Examples in This Manual", for a description of the multimedia application and table
The following example is provided in SQL and applies to all the programmatic environments:
/* Store records in the archive table VoiceoverLib_tab: */ INSERT INTO VoiceoverLib_tab VALUES ('George Washington', EMPTY_CLOB(), 'Robert Redford', 1, NULL); /* Insert values into Voiceover_tab by selecting from VoiceoverLib_tab: */ INSERT INTO Voiceover_tab (SELECT * from VoiceoverLib_tab WHERE Take = 1);