DEVFYI - Developer Resource - FYI

Difference between NO DATA FOUND and %NOTFOUND?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

537. Difference between NO DATA FOUND and %NOTFOUND?

NO DATA FOUND is an exception raised only for the SELECT....INTO statements when the where clause of the querydoes not match any rows. When the where clause of the explicit cursor does not match any rows the %NOTFOUND attribute is set to TRUE instead.

(Continued on next question...)

Other Interview Questions