Maybe this will help you out:
declare
cursor c_t1
is
select * from table1;
begin
for vc_t1 in c_t1
loop
update table2
set date1 = vc_t1.date
where acct = vc_t1.acct;
end loop;
commit;
end;
/
|
Results 1 to 5 of 5
Thread: SQL HelpThreaded View
|
Click Here to Expand Forum to Full Width |