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 rename an index in oracle?

1120


Explain the use of online redo log files in oracle.

1040


How to run the anonymous block again?

1138


What do you mean by group by clause?

1051


how do u setup a replication site?

1994


Difference between varchar and varchar2 data types?

1191


please explain.. DB architecture ...

2029


Who developed oracle & when?

1012


What are the different types of partitions in oracle?

982


Explain the use of grant option in exp command.

1067


State any two functions of oracle?

1048


How to start your 10g xe server from command line?

1076


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.

2003


How to empty your oracle recycle bin?

1029


When system tablespace is created?

1046