SQL> declare
  2   cursor t1 is select empno from emp;
  3   empno emp.empno%type;
  4  begin
  5   open t1;
  6   loop
  7    fetch t1 into empno;
  8    exit when t1%notfound;
  9    dbms_output.put_line(t1%rowcount);
 10   end loop;
 11   close t1;
 12  end;
 13  /
1
2
3
4
5
6
7
8
9
10
11
12
13
14

PL/SQL procedure successfully completed.

SQL> begin
  2   update emp set sal=sal where sal < 3000;
  3   dbms_output.put_line(sql%rowcount || ' rows updated');
  4  end;
  5  /
11 rows updated

PL/SQL procedure successfully completed.

SQL> DECLARE
  2   CURSOR c1 IS
  3   SELECT empno, ename
  4   FROM emp
  5   WHERE deptno = 10;
  6   c2 c1%ROWTYPE;
  7  BEGIN
  8   OPEN c1;
  9    LOOP
 10     FETCH c1 INTO c2;
 11     EXIT WHEN c1%NOTFOUND;
 12    END LOOP;
 13   DBMS_OUTPUT.PUT_LINE('Cursor will return '||c1%ROWCOUNT||' rows.');
 14   CLOSE c1;
 15  END;
 16  /
Cursor will return 3 rows.

PL/SQL procedure successfully completed.

SQL> create table t as select rownum id from user_objects where rownum < 10;

Table created.

SQL> select id
  2  ,      count(*) over () as number_of_rows
  3  from   t
  4  /

        ID NUMBER_OF_ROWS
---------- --------------
         1              9
         2              9
         3              9
         4              9
         5              9
         6              9
         7              9
         8              9
         9              9

9 rows selected.