select statement does not retrieve any records. what
exception is raised?
- 2 Answers
- 4862 Views
- I also Faced
- E-Mail Answers
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 |
List the various oracle database objects?
After update how do u know how many records got updated
How to use "out" parameter properly?
What are Clusters ?
What are named parameters?
What is a Private Synonyms ?
what is the use of system.effective.date variable in oracle?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
What is Row Chaining ?
does the query needs a hint to access a materialized view?
What are the ways tablespaces can be managed and how do they differ?
Explain oracle instance.
Oracle General 
