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.

After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?

3 Answers   IBM,

---

What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,

---

is it possible to run the interface without using oracle apps?

2 Answers   Accenture,

---

Can function be overload?

4 Answers  

---

Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,

---

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

3 Answers   Oracle,

---

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

5 Answers   Amdocs,

---

How you will Diaplay the Company LOGO In report.Can anyone knows please give solution

8 Answers   TCS,

---

Can anybody tell me, What is the Implementation Process?

2 Answers   TCS,

---

Tell me how to find the custom directory in front end?

0 Answers  

---

In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?

9 Answers   TCS,

---

How will U link GL with OU in Multi-org environment.

3 Answers   Convergys,

---