Live ORACLE

DECLARE

  CURSOR c1 IS

    SELECT last_name,

           salary

    FROM   employees

    WHERE  ROWNUM < 11;

   the_name    employees.last_name%TYPE;

   the_salary  employees.salary%TYPE;

BEGIN

  IF c1%ISOPEN = false THEN -- cursor was not already open

 

    OPEN c1;

  END IF;

 

  FETCH c1 INTO the_name,the_salary;

 

  CLOSE c1;

END;

/

Using %ISOPEN