|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
External LOBs (BFILEs), 35 of 41
"Use Case Model: External LOBs (BFILEs)" for all basic operations of External LOBs (BFILES).
This procedure describes how to UPDATE a BFILE by selecting a BFILE from another table.
There is no copy function for
BFILEs, so you have to use
SELECT if you want to copy a
BFILE from one location to another. Because
BFILEs use reference semantics instead of copy semantics, only the
BFILE locator is copied from one row to another row. This means that you cannot make a copy of an external
LOB value without issuing an operating system command to copy the operating system file.
Use the following syntax references:
This example updates the table, Voiceover_tab by selecting from the archival storage table,
The example is provided in SQL and applies to all programmatic environments: