Live ORACLE

DECLARE

 CURSOR c1 IS

   SELECT last_name

   FROM   employees

   WHERE  ROWNUM < 11;

  NAME  employees.last_name%TYPE;

BEGIN

 OPEN c1;



 LOOP

   FETCH c1 INTO NAME;

 

   EXIT WHEN c1%NOTFOUND

              OR c1%NOTFOUND IS NULL;

 

   dbms_output.Put_line(c1%ROWCOUNT

                        ||'. '

                        ||NAME);

 

   IF c1%ROWCOUNT = 5 THEN

     dbms_output.Put_line('--- Fetched 5th record ---');

   END IF;

 END LOOP;



 CLOSE c1;

END;

/

1. Abel
2. Ande
3. Atkinson
4. Austin
5. Baer
--- Fetched 5th record ---
6. Baida
7. Banda
8. Bates
9. Bell
10. Bernstein

PL/SQL procedure successfully completed.

Using %ROWCOUNT