select statement does not retrieve any records. what
exception is raised?
- 2 Answers
- 4947 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
Why use resource manager in Oracle?
What is a cursor variable?
What is the difference between a hot backup and a cold backup in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What do you understand by a database object? Can you list a few of them?
What is a server parameter file in oracle?
What is coalesce function?
What is procedure overloading in oracle?
What is raw datatype in oracle?
What are the numeric comparison operations?
How to open and close an explicit cursor in oracle?
How to download oracle database 10g xe?
What is connection pool in oracle?
Where is the export dump file located?
What is the difference between I and G in Oracle?
