Difference between NO DATA FOUND and %NOTFOUND?
Answer / nishi
NO_DATA_FOUND is pre defind exception of oracle. when we can't get any data from the table for any query. In that case we will get error.
%NOT FOUND is one of the attribute of explicit cursor. when can't get any data from explicit cursor in that case
%NOT FOUND will returns true otherwise it returns false.
Is This Answer Correct ? | 9 Yes | 0 No |
What is oracle latest version?
what is the use of ondelete cascade?
Why does Oracle not permit the use of PCTUSED with indexes?
How to convert characters to dates in oracle?
What is a data segment ?
What is a trigger and what are its types?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
How to delete all rows a table in oracle?
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
How can we view last record added to a table?
How to store only time; not date and time?
What are the types of Database Links ?