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
How to write a query with an inner join in oracle?
List the various oracle database objects?
How do I reset a sequence in oracle?
What is the quickest way to export a table to a flat file?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to assign data of the deleted row to variables?
How to count duplicated values in a column in oracle?
What exactly do quotation marks around the table name do?
What is oracle latest version?
How do I connect to oracle?
Differentiate between pre-select and pre-query?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is parameterized cursor in oracle?
Does oracle database need java?
How to use "for" statements in oracle?