InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Difference Between No Data Found And %notfound |
|
Answer» NO DATA FOUND is an exception which is raised when either an implicit query RETURNS no data, or you ATTEMPT to reference a ROW in the PL/SQL table which is not yet defined. SQL%NOTFOUND, is a BOOLEAN attribute indicating whether the recent SQL statement does not MATCH to any row. NO DATA FOUND is an exception which is raised when either an implicit query returns no data, or you attempt to reference a row in the PL/SQL table which is not yet defined. SQL%NOTFOUND, is a BOOLEAN attribute indicating whether the recent SQL statement does not match to any row. |
|