Multiple choice technology programming languages

How many rows can be retrieved using a SELECT INTO statement in an application?

  1. none

  2. 1

  3. 2

  4. unlimited

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In PL/SQL or embedded SQL, a SELECT INTO statement must return exactly one row. Returning zero rows raises a NO_DATA_FOUND exception, and returning more than one row raises a TOO_MANY_ROWS exception.