开始
VARIABLE rows_deleted varchar2(30) DECLARE v_empno emp_cpy.empno%TYPE:=7900; BEGIN DELETE FROM emp_cpy WHERE empno=v_empno; :rows_deleted:=(SQL%ROWCOUNT || 'row deleted.'); END; / PRINT rows_deleted
运行结果：
anonymous block completed ROWS_DELETED ------------- 1row deleted.
结束
本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/archive/2012/11/13/2768214.html，如需转载请自行联系原作者
