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...

select statement does not retrieve any records. what
exception is raised?

Answer Posted / madhu

Here two ways is there
you are using single select statement it display no rows
selected message.

If you are using in PL/SQL BLOCK at that time it raise the
error

NO_DATA_FOUND( IF YOU DECLARED) OTHER WISE IT GO FOR
WHEN OTHERS_THEN EXCEPTION HANDER.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to connect the oracle server as sysdba?

1077


What are the parameters that we can pass through a stored procedure?

1064


What are the ansi data types supported in oracle?

947


Is truncate autocommit in oracle?

1087


How do I manually uninstall oracle client?

1087


How to change program global area (pga) in oracle?

1093


Explain oracle insert into command?

1112


what is the use of system.effective.date variable in oracle?

1116


How can we find out the duplicate values in an oracle table?

1046


What is the fastest query method to fetch data from the table?

1361


What is oracle and what are its different editions?

1065


Explain parameter file in oracle.

1029


What is integrity and what is constraint??Explain with example

2284


How to lock and unlock a user account in oracle?

1106


Is there any function in oracle similar like group_concat of mysql?

1053