Declare
Cr_test is
select a
from test;
begin
if Cr_test%rowcountDeclare
2cursor Cr_test is select id from test;
3begin
4 dbms_output.put_line('Cr_test%rowcount:'||Cr_test%rowcount);
5 if Cr_test%rowcountDeclare
2cursor Cr_test is select id from test;
3begin
4open cr_test;
5dbms_output.put_line('Cr_test%rowcount:'||Cr_test%rowcount);
6 if Cr_test%rowcountDeclare
2var_id test.id%type;
3cursor Cr_test is select id from test;
4begin
5open cr_test;
6fetch cr_test into var_id;
7dbms_output.put_line('Cr_test%rowcount:'||Cr_test%rowcount);
8 if Cr_test%rowcount <= 0 then
9dbms_output.put_line('No rows.');
10 end if;
11 close cr_test;
12end;
13/
Cr_test%rowcount:1
PL/SQL 过程已成功完成。
