InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Difference Between No Data Found And %notfound? |
|
Answer» 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. 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. |
|