we have select statement in that two exceptions that
returns no value. In that which exception will raise?
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 |
where the accounting related data is stored ? all type of accounting related data costing etc...
PL/SQL stored procedure parameters?
in which table sub inventory related information for item is stored?
3 Answers chain sys, Scan Steel,
hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411
what is pl/sql table and pl/sql records? what is the use of that?
In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?
Plz anybody send me Technical specification for AP Interface
How to create user and how u attach with responsibility.
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
what are the different calculation columns available in reports?
what are the functions you are used in utl_file at the time of transferring the data?