Home » PL/SQL MCQs

Which exception is rose when there is no other clause in the 'WHEN' clause of a CASE statement, and none of the choices in the 'WHEN' clause have been selected?

120. Which exception is rose when there is no other clause in the "WHEN" clause of a CASE statement, and none of the choices in the "WHEN" clause have been selected?

1. INVALID_CURSOR
2. DUP_VAL_ON_INDEX
3. VALUE_ERROR
4. CASE_NOT_FOUND

Answer: D) CASE_NOT_FOUND

Explanation:

CASE_NOT_FOUND exception is rose when there is no other clause in the "WHEN" clause of a CASE statement, and none of the choices in the "WHEN" clause have been selected.