del_rows.sql

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

create or replace PROCEDURE del_rows 
  (v_id       NUMBER)
IS
  v_rows_deleted  NUMBER;
BEGIN
  DELETE FROM test WHERE id = v_id;
  v_rows_deleted := SQL%ROWCOUNT;
  dbms_output.put_line(TO_CHAR(v_rows_deleted)||' rows deleted.');
END del_rows;
/