Answer Posted / 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 |
Post New Answer View All Answers
Explain enable novalidate constraint.
How to use fetch statement in a loop?
Name the three major set of files on disk that compose a database in Oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Whether any commands are used for months calculation? If so, what are they?
Will you be able to store pictures in the database?explain.
What is a connect identifier?
How to return top 5 rows in oracle?
How to best split csv strings in oracle 9i?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is the difference between 10g OEM and 11g OEM?
Explain oracle instance.
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What happens to the current transaction if the session is killed?
Can I create users through internet explorer in oracle 10g?