Oracle9i Application Developer's Guide - Large Objects (LOBs) Release 1 (9.0.1) Part Number A88879-01 |
|
Internal Persistent LOBs, 41 of 43
See:
"Use Case Model: Internal Persistent LOBs Operations", for all Internal Persistent LOB operations. |
This procedure describes how to use UPDATE as SELECT with LOBs.
Not applicable.
Use the following syntax reference:
This example updates voice-over data from archival storage (VoiceoverLib_tab
) by means of a reference:
The examples are provided in SQL and apply to all programmatic environments:
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;
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|