17,082
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure update_Job as
begin
for varCode in (select a.fields1,a.fields2 from A1 a) loop
for varStr in (select a.num,a.fields1,a.fields2 from A2 a
where a.fields2 = varCode.Fields2 and a.fields1 != varCode.Fields1) loop
update A2 t
set t.fields1 = varCode.Fields1
where t.num = varStr.Num;
commit;
end loop;
end loop;
end update_Job;