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
5682 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

What are the common oracle dba tasks?

0 Answers

can we insert any row to dual table if i got the permission from DBA

5 Answers HCL, Tesco,

What do you mean by redo log file mirroring?

0 Answers

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers

What is recycle bin in Oracle?

0 Answers MCN Solutions,

How many types of tables supported by oracle?

0 Answers

How to rename an existing table?

0 Answers

Please explain compound trigger in oracle?

0 Answers

What is a directory object?

0 Answers

Explain the dml?

0 Answers

Which dictionary tables and/or views would you look at to diagnose a locking issue?

0 Answers

For more Oracle General Interview Questions Click Here