Oracle 更新查询是否在密钥持有者中返回受影响的行值？

SQL> create table t as select rownum x, rownum*10 y
  2  from dual
  3  connect by level <= 5;

Table created.

SQL>
SQL> select * from t;

         X          Y
---------- ----------
         1         10
         2         20
         3         30
         4         40
         5         50

SQL> set serverout on
SQL> b例如in
  2    update t set y = y + 1 where x <= 3;
  3
  4    dbms_output.put_line('rows changed = '||sql%rowcount);
  5  end;
  6  /
rows changed = 3

PL/SQL procedure successfully completed.

SQL> declare
  2    type pk_list is table of number index by pls_int例如er;
  3    pk pk_list;
  4  b例如in
  5    update t set y = y + 1 where x <= 3
  6    returning x bulk collect into pk;
  7
  8    for i in 1 ..pk.count loop
  9      dbms_output.put_line('affected x was '||pk(i));
 10    end loop;
 11  end;
 12  /
affected x was 1
affected x was 2
affected x was 3

PL/SQL procedure successfully completed.
复制