Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between NO DATA FOUND and %NOTFOUND?
- 1 Answers
- 4493 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 |
What does `(+)` do in a where clause?
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
which is the best training centre for learning oracle?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
select * from emp what happened internally when we write this query in the sql prompt?
What are virtual columns?
How to export your connection information to a file?
What do you mean by merge in oracle?
what is difference between table and view? where to use views? thanks in advance!
What is Segment Advisor in Oracle?
What is the difference between post-database commit and post-form commit?
Write a trigger example in oracle?
Oracle General 
