Interested to Buy Any Domain ? << Click Here >> for more details...
select statement does not retrieve any records. what
exception is raised?
- 2 Answers
- 5687 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 |
What is Database Link ?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Whether any commands are used for months calculation? If so, what are they?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
What are various constraints used in SQL?
What is the difference between a primary key & a unique key?
How to connect to a local oracle 10g xe server?
What is a Garbage Collection? and what is full recursive Garbage collection?
How to create an initialization parameter file?
Explain the use of grant option in exp command.
Oracle General 
