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

what happened to the global index when I truncate the data in one of the partition?

2008


What are the ways tablespaces can be managed and how do they differ?

2336


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2444


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2043


What is a directory object?

1068


What is the relation of a user account and a schema in oracle?

1059


How to sort the query output in oracle?

1001


What is a cursor variable?

1095


can u plz provide me oca sql dumps please i need them

1930


What is index in Oracle?

1053


How to upsert (update or insert into a table)?

979


How to empty your oracle recycle bin?

1009


How do I reset a sequence in oracle?

1076


How many anonymous blocks can be defined?

1157


How to insert multiple rows with one insert statement in oracle?

1055