Difference between NO DATA FOUND and %NOTFOUND?
- 1 Answers
- 3860 Views
- I also Faced
- E-Mail Answers
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 |
How to export your connection information to a file?
What is the usage of analyze command in oracle?
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
What is a trace file and how is it created in oracle?
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
What is a Database instance ? Explain?
How to connect the oracle server as sysdba?
How do I spool to a csv formatted file using sqlplus?
Difference between NO DATA FOUND and %NOTFOUND?
What privilege is needed for a user to query tables in another schema?
What is difference between Rename and Alias?
What are the attributes that are found in a cursor?
Oracle General 
