Multiple choice

Which of the following statements is/are incorrect about % ROWCOUNT function in PL/SQL cursor?

  1. It returns the invalid cursor error in case of cursor is not declared.

  2. It returns the number of rows fetched.

  3. An iteration gives the count of rows for the defined cursor.

  4. It returns TRUE if a successful fetch has been executed.

  5. If no row is returned, then this function returns an error.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This is false as it does not return this value in case of successful fetched of row.

Keep practicing — related questions