Multiple choice technology databases

Which one of the following provides you with the number of records affected by the last DML statement?

  1. SQL%ROWCOUNT

  2. SQL%COUNT

  3. SQL%FOUND

  4. SQL%NUM_ROWS
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In PL/SQL, the implicit cursor attribute SQL%ROWCOUNT returns the exact number of rows affected by the last executed DML statement. SQL%FOUND returns a boolean, while SQL%COUNT and SQL%NUM_ROWS are not valid PL/SQL implicit cursor attributes.

Keep practicing — related questions