what is the difference between procedure and function
- 4 Answers
- 6045 Views
- I also Faced
- E-Mail Answers
Answer Posted / venki_discussions
procedure perform one or more actions it may return or may
not return values if u want to return procedure ill return
multiple values.we can use procedures in oracel apps also
function perform one or more actions and it must return any
value multiple values will not return function.functions
we cant use in oracle apps.we can perform functions on SQL
prompt itslef.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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.
Can u give the Documentation of Custom.pll in oracle apps
What is a flexfield? List out its types.
Explain what are the tables of auto invoice?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Explain oracle apps architecture.
How can you achieve loose coupling in soa framework?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What are the different components you should consider while defining a responsibility in oracle apps?
What are the different components of soa suite?
How to create a purchase order without a requisition?
what are the different transaction clauses in AR?
tell my any difficult situtation you solved in your experience in your company?
How do you register report in oracle apps?
What is count(*) from po_vendors(any table)?
