Home » PL/SQL MCQs

What is TRUE about %ROWCOUNT in PL/SQL Cursor?

84. What is TRUE about %ROWCOUNT in PL/SQL Cursor?

1. A SELECT INTO statement or DML statements like INSERT, DELETE, AND UPDATE do not result in any rows being affected.
2. Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command.
3. Both A. and B.
4. None of the above

Answer: B) Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command

Explanation:

Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command.