SQL%ROWCOUNT可以用在PL/SQL中，用于显示SELECT或DML语句执行了多少行。

下面是11g文档中的描述。

SQL%ROWCOUNT Attribute: How Many Rows Were Affected?
SQL%ROWCOUNT returns:
NULL if no SELECT or DML statement has run
Otherwise, the number of rows returned by a SELECT statement or affected by a DML statement

通过一个简单的匿名块，来进行测试。

SQL> select * from test;
         A          B
---------- ----------
   1494928        599
   1626437        681
   1620661        694
   1510847        684
   1838501        774
   1598577        658
   1683504        725

已选择7行。

SQL> set serveroutput on
SQL> show serveroutput
serveroutput ON SIZE UNLIMITED FORMAT WORD_WRAPPED
SQL> declare
2 begin
3    delete from test;
4    dbms_output.put_line(SQL%ROWCOUNT);
5    rollback;
6    delete from test where a = 1494928;
7    dbms_output.put_line(SQL%ROWCOUNT);
8    rollback;
9    delete from test where a = 100;
10    dbms_output.put_line(SQL%ROWCOUNT);
11    rollback;
12 end;
13 /
7
1
0

PL/SQL 过程已成功完成。

ITPub博客

SQL%ROWCOUNT的简要说明

最新文章