oracle 中使用游标更新数据
declare cursor cur is select * from test for update ;
idNum number;
r test%rowtype;
begin
idNum:=0;
open cur;
loop
fetch cur into r;
exit when cur%notfound;
idNum:=idNum+1;
update test set id =idNum where current of cur;
end loop;
commit;
close cur;
end;
ORACLE 多表更新
tba 和tbb 表的id相关联,要将tba的name更新为tbb 的name
UPDATE
(
SELECT A.name aname,B.name bname
FROM tba A,tbb B WHERE a.id=B.id
)
SET aname=bname