Answer / abhi choudary

procedure may or may not return a value, but function must return a value.
procedure can not be used in select statement but function can use except one situation whenever select stmt contains dml operation thats time not possible to use

Answer / raghu

procedure may or may not return a value.
function return a value
procedure will be storeed in db as a compiled object
but funtion will be stored as text what we written

What is a value set? List its various types.

0 Answers  

---

Registering parametric report?

1 Answers  

---

how can we return morethan one parameters in procedure?

2 Answers  

---

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  

---

Can u attach Request set with in the Request set?

2 Answers   Satyam,

---

---

In unix Schell sript what is very 1st line to be wriiten .

2 Answers   IBM,

---

how to call report from oracle oracle apps11i?

3 Answers   Genpact,

---

tell me the scenarios of between pages in reports

1 Answers   TCS, Wipro,

---

can we use commit in trigger? If yes how?

2 Answers   Cap Gemini, TCS,

---

what is lexical parameter?

3 Answers   TCS,

---

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.

0 Answers   Accenture,

---

how to avoid duplicate data while uploading data from flatfile to staging table? some validations

5 Answers   Amdocs,

---