Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between NO DATA FOUND and %NOTFOUND?
- 1 Answers
- 4479 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 do I find the database name in oracle?
How to add another datafile to a tablespace?
T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Explain the family trees and connection by clause
what are actual and formal parameters?
How to define a data field as not null?
What happens to the indexes if a table is recovered?
how to create a new database in oracle?
What's dateware house and what's clustor with practicle example
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
How to store pictures on to the database?
Oracle General 
