UPDATE a BFILE by Selecting a BFILE From Another Table

Figure 11-31 Use Case Diagram: UPDATE a BFILE by Selecting a BFILE From Another Table

See Also: "Use Case Model: External LOBs (BFILEs)" for all basic operations of External LOBs (BFILES).

Purpose

This procedure describes how to UPDATE a BFILE by selecting a BFILE from another table.

Usage Notes

There is no copy function for BFILEs, so you have to use UPDATE as 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.

Syntax

Use the following syntax references:

• SQL (Oracle8i SQL Reference), Chapter 7, "SQL Statements" -- UPDATE

Scenario

This example updates the table, Voiceover_tab by selecting from the archival storage table, VoiceoverLib_tab./

Examples

The example is provided in SQL and applies to all programmatic environments:

• SQL: Update a BFILE by Selecting a BFILE From Another Table

SQL: Update a BFILE by Selecting a BFILE From Another Table

UPDATE Voiceover_tab
    SET (originator,script,actor,take,recording) =
       (SELECT * FROM VoiceoverLib_tab VLtab WHERE VLtab.Take = 101);