After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent beer selection!
|
Oracle
»
PL-SQL
»
Join
»
Update
Update from one table to another
Oracle Update - Where You Need to Join.
Oracle does not support updating one table from another, in a join ;
it does support updates via sub-selects, which are a bit strange,
but seem to work.
In the below example, TWO columns on the target table are updated
from two columns on another table.
set serveroutput on size 4444
create or replace procedure P_invoice_sync (v_invoice_id in integer)
is
begin
update invoice t1
set (inv_total, inv_tax) =
( select inv_total,inv_tax from import_invoice_data t2
where t2.invoice_id = v_invoice_id and
t1.invoice_id = t2.invoice_id and
t1.client_id = t2.client_id ) ;
commit;
end;
/
show errors
|
|
|
|
