Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between NO DATA FOUND and %NOTFOUND?
- 1 Answers
- 4403 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 assign a table row to a record variable?
How to load data through external tables?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What is the usage of control file in oracle?
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
What is oracle and what are its different editions?
How to use an explicit cursor without open statements?
What is a relational database management system?
What is Private Database Link ?
Can we create more than one constraint to column ?
Explain the use of ignore option in imp command.
Oracle General 
