update table without specifying column names
From: Xifer <ark_at_im.net>
Date: Thu, 10 May 2001 15:36:54 +0100
Message-ID: <3AFAA786.4ABE5FCF_at_im.net>
Date: Thu, 10 May 2001 15:36:54 +0100
Message-ID: <3AFAA786.4ABE5FCF_at_im.net>
Is it possible to update a TABLE directly from a RECORD based on the TABLE directly, e.g.
declare
summary_r summary_t%ROWTYPE;
begin
update summary_t (summary_r) where summary_t.col1 = summary_r.col1;
commit;
end;
I've been reading the manual but it seems to say I need to use an object table. Received on Thu May 10 2001 - 16:36:54 CEST