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.

what are the difference between 11.5.7 and 11.5.9 in oracle apps

4 Answers  

---

what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions

1 Answers  

---

How to find which company will be conducted Oracle appa interview? Plz help me

3 Answers  

---

how can u find the status in po?

1 Answers  

---

what is difference between po_headers_all and po_headers

5 Answers   Deloitte, Wipro,

---

How to link between inventory and OrderManagement.

1 Answers   Zensar,

---

HOW CAN U KNOW TABLE IS REGISTERD IN APPS?

3 Answers  

---

Can anybody tell me, What is the Implementation Process?

2 Answers   TCS,

---

where we will put the control file ,where we will run sql star loader what is the cmd?

1 Answers   Cap Gemini, KPMG,

---

How can u find custom top? where its located? How to find custom top in front end?

1 Answers  

---

what do you mean by value sets

8 Answers   Convergys,

---

What are the validations you don in .CTL file in inbound interface process?

1 Answers  

---