SQL%ROWCOUNT应用

DECLARE
v_row_delete VARCHAR2(30);
v_empno emp.employee_id%TYPE:=176;
BEGIN
delete from emp where employee_id=v_empno;
v_row_delete:=(SQL%ROWCOUNT||' row deleted.');
DBMS_OUTPUT.PUT_LINE(v_row_delete);
END;
/

delete update ,insert 在pl/sql块里面执行，不会出现sql中统计的数目的，需要使用SQL%ROWCOUNT来显示。

[oracle@dg1 ~]$ sqlplus hr/hr

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 31 10:35:33 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> @2.sql
1 row deleted.

PL/SQL procedure successfully completed.

[oracle@dg1 ~]$ sqlplus hr/hr

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 31 10:35:33 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> @2.sql
1 row deleted.

PL/SQL procedure successfully completed.