update_rows.sql

来自「学习PL/SQL时收集的一些经典的SQL源代码」· SQL 代码 · 共 15 行

create or replace PROCEDURE update_rows 
  (v_id       NUMBER)
IS
  v_rows_deleted  NUMBER;
BEGIN
  update test set name='1111' where id = v_id;
  v_rows_deleted := SQL%ROWCOUNT;
  dbms_output.put_line('1111:'||TO_CHAR(v_rows_deleted)||' rows deleted.');

  update test set name='2222' where id = v_id+1;
  v_rows_deleted := SQL%ROWCOUNT;
  dbms_output.put_line('2222:'||TO_CHAR(v_rows_deleted)||' rows deleted.');
END update_rows;
/