Multiple choice technology databases

Which one of the following is not an Implicit Cursor attributes

  1. SQL%Found

  2. SQL%ISOPEN

  3. SQL%NOTFOUND

  4. SQL%ROWCOUNT
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Implicit cursors support attributes like SQL%FOUND, SQL%NOTFOUND, and SQL%ROWCOUNT. However, SQL%ISOPEN always evaluates to FALSE because Oracle automatically closes implicit cursors after execution.

Keep practicing — related questions