Interested to Buy Any Domain ? << Click Here >> for more details...
select statement does not retrieve any records. what
exception is raised?
- 2 Answers
- 5772 Views
- I also Faced
- E-Mail Answers
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 define an explicit cursor in oracle?
How many types of cluster table in Oracle?
What is connection pooling in oracle?
what is the difference between substr and instr function in oracle?
Please explain oracle data types with examples?
How to change program global area (pga) in oracle?
How to bring a tablespace offline?
How can we find out the duplicate values in an oracle table?
How to create a new tablespace in oracle?
List the types of joins used in writing subqueries?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to use subqueries with the in operator using oracle?
Describe an oracle table?
How to view the data files in the current database?
What is catalog in Oracle?
