select statement does not retrieve any records. what
exception is raised?
Answers were Sorted based on User's Feedback
Answer / 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 |
What are oracle functions?
How to define a procedure inside another procedure?
How can we Update a table with out using UPDATE command?
How to use in conditions in oracle?
how to genarate random numbers in oracle for particular row?
What is query image?
What are the attributes of the cursor?
what is dynamic SGA and static SGA
What is a Temporary Segment ?
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
Explain the blob datatype?
how to delete all duplicate records from a table using subquery?