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 |
How to define a variable of a specific record type?
What is the difference between formal parameters and actual parameters?
What is Partitions in Table ?
How to create id with auto_increment on oracle?
What is PL/SQL ?
What is self-referential integrity constraint ?
How to calculate date and time differences in oracle?
What is TNS File
What are the different types of synonyms?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What are the different types of failures that occur in Oracle database?
what is the difference between UNION AND UNIONALL