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.

Is it possible to do purchase order without requisition?

8 Answers  

---

what is tuning in oracle apps technical

3 Answers   TCS,

---

is UOM maintained at master level or organization level or both?

3 Answers   Scan Steel,

---

After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers   HCL,

---

How will you get the concurrent program output as email?

3 Answers   IBM, KPIT,

---

---

Presently u are working in which version?

4 Answers   Accenture,

---

q)what are the validations in sql*loader

0 Answers   Accenture,

---

what r the objects u have to do in u experiance

1 Answers  

---

What is multoorg and what is it's level or structure

4 Answers   IBM,

---

how many sections are there in report?

1 Answers  

---

What is oracle soa suite and what are its different components?

0 Answers  

---

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

2 Answers   Accenture,

---