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