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
what happened to the global index when I truncate the data in one of the partition?
What are the ways tablespaces can be managed and how do they differ?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is a directory object?
What is the relation of a user account and a schema in oracle?
How to sort the query output in oracle?
What is a cursor variable?
can u plz provide me oca sql dumps please i need them
What is index in Oracle?
How to upsert (update or insert into a table)?
How to empty your oracle recycle bin?
How do I reset a sequence in oracle?
How many anonymous blocks can be defined?
How to insert multiple rows with one insert statement in oracle?