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 write a query with an inner join in oracle?

788


List the various oracle database objects?

819


How do I reset a sequence in oracle?

844


What is the quickest way to export a table to a flat file?

753


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2000


How to assign data of the deleted row to variables?

818


How to count duplicated values in a column in oracle?

785


What exactly do quotation marks around the table name do?

729


What is oracle latest version?

848


How do I connect to oracle?

765


Differentiate between pre-select and pre-query?

840


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1868


What is parameterized cursor in oracle?

815


Does oracle database need java?

752


How to use "for" statements in oracle?

790