Example Of Explicit Cursor

%ROWCOUNT and %NOTFOUND: Example

This Example  retrieves the first  5 employees one by one. This example shows how 

%ROWCOUNT and %NOTFOUND attributes can be used for exit conditions in a loop.

SET SERVEROUTPUT ON

DECLARE

  empno  employees.employee_id%TYPE;

  ename  employees.last_name%TYPE;

  CURSOR emp_cursor IS SELECT employee_id,

  last_name FROM employees;

BEGIN

  OPEN emp_cursor;

  LOOP

   FETCH emp_cursor INTO empno, ename;

   EXIT WHEN emp_cursor%ROWCOUNT > 5 OR 

                     emp_cursor%NOTFOUND;       

   DBMS_OUTPUT.PUT_LINE(TO_CHAR(empno)

                       ||' '|| ename);

  END LOOP;

  CLOSE emp_cursor;

END ;