Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between NO DATA FOUND and %NOTFOUND?
- 1 Answers
- 4385 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 |
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
How to turn on or off recycle bin for the instance?
Difference between hot backup vs. Cold backup?
What is Java Pool in Oracle?
What are the differences between lov and list item?
What is difference between SUBSTR and INSTR?
Differnce between view and index
What is the function of Optimizer ?
What do database buffers contain?
How to update a table row with a record?
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
what is the syntax of ALTER command?
Oracle General 
