Multiple choice technology databases

Which one of the following is not an Explicit Cursor attributes

  1. cursor_name%Found

  2. cursor_name%NOTFOUND

  3. cursor_name%OPEN

  4. cursor_name%ROWCOUNT
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Explicit cursor attributes in Oracle are: %FOUND (row fetched), %NOTFOUND (no row fetched), %ISOPEN (cursor state), and %ROWCOUNT (rows fetched so far). %OPEN is not a valid attribute - the correct one is %ISOPEN. The question asks which is NOT an attribute, making option C correct.

Keep practicing — related questions