we have select statement in that two exceptions that returns no value. In that

we have select statement in that two exceptions that
returns no value. In that which exception will raise?

Question Posted / chandrasekhar.bs

Answers were Sorted based on User's Feedback

we have select statement in that two exceptions that returns no value. In that which exception wil..

Answer / sumeet

EVEN IF THERE ARE TWO EXCEPTIONS FIRST ONE WILL BE RAISED
AND TRANSACTION WILL TERMINATE :

NO_DATA_FOUND exception will raise.

Is This Answer Correct ?

4 Yes

0 No

we have select statement in that two exceptions that returns no value. In that which exception wil..

Answer / ramesh babu v

It is not possible to write the more than one exception at a
time in select statement

Is This Answer Correct ?

1 Yes

1 No

More Oracle Apps Technical Interview Questions

What are the different components you should consider while defining a responsibility in oracle apps?

HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?

what is the standard program for blanket po to process data from interface table to bace table

can we execute one concurrent program through another concurrent program?

what is organization id

how to create requst set in oracle apps and how to send muliple requests at a time,

If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems

WHAT IS REFCURSOR IN ORACLE ?

List the types of flexfield?

what is meant by bind parameter?

For more Oracle Apps Technical Interview Questions Click Here