更新游标的用法

 更新游标包括两部分：1. 声明游标时，cursor mycur is select * from test for update --锁定了表的整行.

2. cursor mycur is select * from test for update of name --只锁定name这个列

where current of  mycur 只更新当前行。

 

 

 更新游标包括两部分：

declare
        cursor mycur is select * from test for update;
        myrec test%rowtype;
begin
        open mycur;
        fetch mycur into myrec;
        while mycur%found loop
                update test set name = name || 'yes' where current of mycur;
                fetch mycur into myrec;
        end loop;
        close mycur;
        commit;
end;