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

2 Answers
6408 Views
I also Faced
E-Mail Answers

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

Post New Answer

More Oracle Apps Technical Interview Questions

where is setup of business group done?

2 Answers TCS,

There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers Satyam,

What are the files you have used in the part of Conversion and Interfaces?

2 Answers Tech Mahindra,

wheather discard file is automatically created or explicty created?can u mention it?

1 Answers CTS,

How to migrate .rdf file from dev instance to test instance?

3 Answers Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers IBM,

what is difference between po_headers_all and po_headers

2 Answers NTT Data,

What is secuirity's in R12 features.

1 Answers KPIT,

How to insert data into two tables using single control file?

3 Answers Oracle, VTI,

What is FORWARD DECLARATION in Packages?

6 Answers British Telecom BT, HCL, Tech Mahindra,

How can u populate data into po_headers_all segment2 column?

1 Answers BirlaSoft,

What is menu.

2 Answers Accenture,

For more Oracle Apps Technical Interview Questions Click Here