Multiple choice technology databases

Which three definitions are associated with implicit cursors?

  1. %rowtype, %toomanyrows, %found

  2. %found, %notfound, %rowcount

  3. %rowtype, %rowcount, %notfound

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Implicit cursor attributes in Oracle PL/SQL are SQL%FOUND (true if rows affected), SQL%NOTFOUND (opposite of FOUND), and SQL%ROWCOUNT (number of rows affected). These are available after any SQL statement.

Keep practicing — related questions