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

How to apply filtering criteria at group level in oracle?

1042


What is merge statement used for?

1024


What is a view and how is it different from a table?

1045


Hi Can any one tell me what are the API's used in requisition import.

1923


Why should I use oracle database?

991


Difference between cartesian join and cross join?

1040


What is the best way to do multi-row insert in oracle?

1067


How to do a full database export?

1109


How to run the anonymous block again?

1132


How can Oracle users be audited?

1115


List out the difference between commit, rollback, and savepoint?

1031


How to use "startup" command to start default instance?

1033


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1068


Explain the difference between a procedure and a function? What do you understand by those terms?

1082


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2344