update_rows.sql

学习PL/SQL时收集的一些经典的SQL源代码

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;
/