select statement does not retrieve any records. what exception is raised?

select statement does not retrieve any records. what
exception is raised?

Question Posted / guest

2 Answers
5699 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

select statement does not retrieve any records. what exception is raised?..

Answer / merly

No_DATA_FOUND exception will be raised

Is This Answer Correct ?

2 Yes

0 No

select statement does not retrieve any records. what exception is raised?..

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

Post New Answer

More Oracle General Interview Questions

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers JPMorgan Chase,

What are advantages fo Stored Procedures?

1 Answers

select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 Answers

How to select an oracle system id (sid)?

0 Answers

What is using clause and give example?

0 Answers

What is Java Pool in Oracle?

0 Answers MCN Solutions,

What is a recycle bin in oracle?