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

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

How to use like conditions in oracle?

0 Answers  


What is the best way to do multi-row insert in oracle?

0 Answers  


How to write a query with a left outer join in oracle?

0 Answers  


how to join query for one source type is oracle another source type is sql server ?

0 Answers   iGate,


What is a Database instance ? Explain?

3 Answers  






What is Database Trigger ?

1 Answers  


1.display list of all users from ur data base.what is the query?

3 Answers   CGI, IBM,


What is the minimum client footprint required to connect c# to an oracle database?

0 Answers  


What is a data segment ?

1 Answers  


How to load data through external tables?

0 Answers  


How to update values in a table in oracle?

0 Answers  


How to use "in out" parameter properly?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)