Answer Posted / 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 |
Post New Answer View All Answers
How to apply filtering criteria at group level in oracle?
What is merge statement used for?
What is a view and how is it different from a table?
Hi Can any one tell me what are the API's used in requisition import.
Why should I use oracle database?
Difference between cartesian join and cross join?
What is the best way to do multi-row insert in oracle?
How to do a full database export?
How to run the anonymous block again?
How can Oracle users be audited?
List out the difference between commit, rollback, and savepoint?
How to use "startup" command to start default instance?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Explain the difference between a procedure and a function? What do you understand by those terms?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?