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 is the difference between view and materialized view in Oracle?
How a tablespace is related to data files?
What is the data type of dual table?
Explain the use of full option in exp command.
What is a cursor and what are the steps need to be taken?
What privilege is needed for a user to create tables in oracle?
What are the differences between number and binary_float in oracle?
Explain about functional dependency and its relation with table design?
Explain constraining triggers.
Explain a data segment?
Whether any commands are used for months calculation? If so, what are they?
How to select some rows from a table in oracle?
What are the differences between char and nchar in oracle?
what is the difference between functional dependecy and multilevel dependency?
How to speed up webrick?
