Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Difference between NO DATA FOUND and %NOTFOUND?

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


Please Help Members By Posting Answers For Below Questions

Explain enable novalidate constraint.

1035


How to use fetch statement in a loop?

973


Name the three major set of files on disk that compose a database in Oracle?

1067


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?

1863


Whether any commands are used for months calculation? If so, what are they?

1042


Will you be able to store pictures in the database?explain.

931


What is a connect identifier?

983


How to return top 5 rows in oracle?

991


How to best split csv strings in oracle 9i?

986


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.

5289


What is the difference between 10g OEM and 11g OEM?

917


Explain oracle instance.

1107


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2075


What happens to the current transaction if the session is killed?

927


Can I create users through internet explorer in oracle 10g?

1020