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
5582 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 commands youd issue to show the explain plan for select

2 Answers

SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>

1 Answers Infosys,

How to compare dates in oracle sql?

0 Answers

ABOUT IDENTITY?

0 Answers HCL,

Describe the different type of Integrity Constraints supported by ORACLE ?

2 Answers

What is the use of Control File ?

3 Answers

What is the difference between Sleep and Wait? (Java)

1 Answers RBS,

why pl sql doesn't support retrieving multiple records

1 Answers Mphasis,

What is the usage of synonyms?

0 Answers

Can we create trigger on materialized view in oracle?

0 Answers

How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.

2 Answers

What is bulk collect in oracle?

0 Answers

For more Oracle General Interview Questions Click Here