Interested to Buy Any Domain ? << Click Here >> for more details...
we have select statement in that two exceptions that
returns no value. In that which exception will raise?
- 2 Answers
- 6393 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Difference between set of books id and ledger id in r12 ?
what is meant by Drill Down in Discoverer report? why it will be use?
Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?
What is template?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
what is tuning in oracle apps technical
How to retry multiple errored workflow processes? What is the access level in workflow used for? How do you define start and end functions in workflow? How does they differ from normal functions? Give me some workflow tables? What is the difference between a function and notification in workflow? I have sent two different notifications to two different users and I want to wait till both they are approved to send 3rd notification. How can you achieve it? What is item type and item key in workflow? How do you use attribute values in workflow messages? How do you use lookups in workflow? What are roles in workflow and how they are used? How do you download or upload a workflow from a server? What are steps to customize the workflow? What functions can you perform from workflow administrator responsibility? To send an email to the user workflow notification is the only way or is there any other ways to send it? Give me some workflow standard procedures? How can you run/start/kickoff workflow? What is wf_engine package used for? How many processes can each workflow contain? What is Runnable option in workflow? At what level it exists? What are different types of attributes in workflow? How do you reassign a notification? What is process in workflow? How can you send direct oracle form link through workflow notifications? How can you send a notification to multiple users? Can you change the list dynamically? Can you send html code in workflow notification? I have sent two different notifications to two different users and I want to wait till atleast one is approved to send 3rd notification. How can you achieve it?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
how to print multi lay outs,muti currency,muti language in xml publisher
wht r the basetables of customer interface?
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.
A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
Oracle Apps Technical 
