NODATAFOUND exception is raised when no rows satisfy the SELECT criteria - PL/SQL Control Structures

Q.  For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?
- Published on 08 Jul 15

a. TOO_MANY_ROWS
b. NO_DATA_FOUND
c. VALUE_ERROR
d. DUP_VAL_ON_INDEX

ANSWER: NO_DATA_FOUND
 
The NO_DATA_FOUND exception is raised when the FETCH statement is not able to find the relevant data that we have asked for.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)