Updating a Row by Selecting a LOB From Another Table

Figure 10-45 Use Case Diagram: Updating a Row by Selecting a LOB from Another Table

Text description of the illustration adl10p17.gif

See: "Use Case Model: Internal Persistent LOBs Operations", for all Internal Persistent LOB operations.

Purpose

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

Usage Notes

Not applicable.

Syntax

Use the following syntax reference:

• SQL: Oracle9i 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 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;