Multiple choice technology databases

OTHERS is super set of all predefined internal exceptions

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In PL/SQL exception handling, OTHERS is indeed a catch-all exception handler that encompasses all predefined exceptions (like NO_DATA_FOUND, TOO_MANY_ROWS, etc.) as well as user-defined exceptions. When you use EXCEPTION WHEN OTHERS, it will catch any exception that hasn't been handled by more specific exception handlers above it. This makes it the most general exception type.

Keep practicing — related questions