Multiple choice technology databases

How can you find within a PL/SQL block, if a cursor is open?

  1. %OPEN

  2. %ISOPEN

  3. 1 & 2

  4. None of the above

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

%ISOPEN is the cursor attribute that returns TRUE if a cursor is open. %OPEN doesn't exist. The syntax is cursor_name%ISOPEN.