Oracle 用于更新游标

SQL> create table t as select * from scott.emp;

Table created.

SQL>
SQL> declare
  2    cursor c is select * from t where job = 'CLERK' for update;
  3    l_increment_pct int := 10;
  4  begin
  5    for i in c loop
  6      update t
  7      set sal = sal * (1 + l_increment_pct/100)
  8      where current of c;
  9
 10      l_increment_pct := l_increment_pct + 1;
 11    end loop;
 12  end;
 13  /

PL/SQL procedure successfully completed.
复制