UPDATE a Row by Selecting a LOB From Another Table

Figure 9-43 Use Case Diagram: UPDATE a Row by Selecting a LOB from Another Table

See: "Use Case Model: Internal Persistent LOBs Basic Operations", for all basic operations of Internal Persistent LOBs.

Purpose

This procedure describes how to use UPDATE as SELECT with LOBs.

Usage Notes

Not applicable.

Syntax

Use the following syntax reference:

• SQL: Oracle8i SQL Reference , Chapter 7, "SQL Statements" -- UPDATE

Scenario

This example updates voice-over data from archival storage (VoiceoverLib_tab) by means of a reference:

Examples

The examples are provided in SQL and apply to all six programmatic environments:

• SQL: Update a Row by Selecting a LOB From Another Table

SQL: Update a Row by Selecting a LOB From Another Table

UPDATE Voiceover_tab SET (Originator, Script, Actor, Take, Recording) =
   (SELECT * FROM VoiceoverLib_tab T2 WHERE T2.Take = 101);

UPDATE Multimedia_tab Mtab
   SET Voiced_ref =
      (SELECT REF(Vref) FROM Voiceover_tab Vref
         WHERE Vref.Actor = 'James Earl Jones' AND Vref.Take = 1)
            WHERE Mtab.Clip_ID = 1;