Interested to Buy Any Domain ? << Click Here >> for more details...
select statement does not retrieve any records. what
exception is raised?
- 2 Answers
- 5575 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 |
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
which clause we are not used in where clause?
What is hash cluster in oracle?
Explain do view contain data?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
how to find full database size
1 Answers BirlaSoft, Consultancy,
How to get a list of all background sessions in the database?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
Define the terms primary key foreign key and also the difference between primary and the unique key
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
How would you extract DDL of a table without using a GUI tool?
Oracle General 
