Oracle 游标操作

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