Answer / kiran kumar

---- is a named pl/sql block to perform a specific task, is
mainly used for calculation purpose.
---- A function is called as part of an exception.
---- Every function should return a value
Example for function
Create or replace
Function get_sal(p_id in emp.emp_no% type)
Return number
Is
v_sal emp.sal%type :=0;
Begin
Select salary into v_salary

From emp

Where emp_no = p_id;
Return v_salary
End get_sal;
End;

Output :
var g_sal number;
Exec :g_sal := get_sal(99);
Print g_salary;

Answer / dipa paul

To tell one sentence, function is -- which return a value
that value can be boolean,char, number and null.

We can use function in oracle form or report bulider and
stored in database.

If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

3 Answers   Accenture,

---

P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?

9 Answers   CSC, IBM, KPIT, Oracle,

---

what r the objects u have to do in u experiance

1 Answers  

---

Do you know what is applysys in oracle application database schema, what is apps?

0 Answers  

---

what are the different calculation columns available in reports?

1 Answers  

---

---

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

3 Answers   Oracle, VTI,

---

What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,

---

in procedure how to return a value

2 Answers   Wipro,

---

Can u suggest me the best institute for Oracle apps Technical in Hyderabad?

16 Answers  

---

In report we have to show two Layout? how it is and how we can see from where it?

3 Answers   IBM,

---

Sys Admin Module?

1 Answers  

---

Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,

---