Multiple choice

Which of the following statements is FALSE about 'Implicit Cursors'?

  1. Oracle performs the open, fetches, and close for you automatically.

  2. It is less efficient than an explicit cursor.

  3. It is less vulnerable to data errors.

  4. It gives you less programmatic control.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

If an implicit SELECT statement returns more than one row, it raises the TOO_MANY_ROWS exception. In this case, execution in the current block terminates and control is passed to the exception section. An implicit cursor is more prone to errors.

Keep practicing — related questions