批量关联一个字段修改另一个字段(可以同表,异表)
这是一个大神教的,特别有效
begin
for res in (select risenpo_uuid as orguuid,risenpo_orgname as orgname from risen_partyorg
)
loop
update risen_partymember pm
set pm.risenpm_partyorguuid = res.orguuid
where pm.risenpm_pbranch = res.orgname;
end loop;
end;