Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between NO DATA FOUND and %NOTFOUND?
- 1 Answers
- 4382 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 |
Respected sir, Please send me technical questions related to oracle apps..
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to find no of saturdays in a month using single sql ?
what is the syntax of ALTER command?
can we pass two out parameters at a time in function?please answer to my question
Explain the use of indexes option in imp command.
how to use sequence and what use of sequence cache
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
How data locks are respected in oracle?
Select the Nth lowest value from a table?
What is Parallel Server ?
What are the execution control statements in oracle?
Oracle General 
