Difference between NO DATA FOUND and %NOTFOUND?
- 1 Answers
- 4024 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 create DSN..Explain?
2 Answers Accenture, BeBo Technologies, Infosys,
Can we create database in oracle using command line ?
What is an oracle user role?
can we pass two out parameters at a time in function?please answer to my question
sql query to get zero records from a table
what is index?
What is a subquery in oracle?
Can a Tablespace hold objects from different Schemes ?
How to drop a stored function?
How do I find my oracle client driver version?
How to start a specific oracle instance?
What is oracle and what are its different editions?
Oracle General 
