In the following code, "dbms_output.put_line(counter)" shows number of rows and "dbms_output.put_line(cur%rowcount); " shows zero. I was expecting it returns number of rows. When do I use %rowcount? Thanks.
set SERVEROUTPUT ON;
declare cursor cur is
select * from citystate;
counter number := 0;
begin
for data in cur loop
counter := counter + 1;
end loop;
dbms_output.put_line(counter);
open cur;
dbms_output.put_line(cur%rowcount);
close cur;
end;