Home » PL/SQL MCQs

When SELECT INTO returns no rows, which pre-defined exception is raised?

118. When SELECT INTO returns no rows, which pre-defined exception is raised?

1. ACCESS_INTO_NULL
2. NO_DATA_FOUND
3. NOT_LOGGED_ON
4. VALUE_ERROR

Answer: B) NO_DATA_FOUND

Explanation:

When SELECT INTO returns no rows, NO_DATA_FOUND pre-defined exception is raised.