SQL@9I> BEGIN
  2      FOR i IN (SELECT e.ename
  3                ,      e.job
  4                ,      e.sal
  5                ,      ROWNUM          ith
  6                ,      <font color=red>COUNT(*) OVER()</font> qty
  7                FROM   emp   e
  8                WHERE  e.ename LIKE '%A%') LOOP
  9          DBMS_OUTPUT.PUT_LINE(i.ename
 10                               || ' is record '
 11                               || TO_CHAR(i.ith)
 12                               || ' of '
 13                               || TO_CHAR(i.qty));
 14      END LOOP;
 15  END;
 16  /
ALLEN is record 1 of 7
WARD is record 2 of 7
MARTIN is record 3 of 7
BLAKE is record 4 of 7
CLARK is record 5 of 7
ADAMS is record 6 of 7
JAMES is record 7 of 7
 
PL/SQL procedure successfully completed.
 
SQL@9I>