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 soa a part of oracle fusion middleware?

0 Answers  

---

how to find the custom directory in front end.

1 Answers   IBM, Sierra Atlantica,

---

What is the difference between BPA AND Contract.

1 Answers   Accenture,

---

What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,

---

when will formula,place holder and summary columns fire in reports?

1 Answers   TCS,

---

---

What is responsibility and how u attach

5 Answers   Accenture,

---

What repots or concurrent program run to transfer data from Inventory to GL.

5 Answers   IBM, iGate,

---

Difference between triggers and procedures?

2 Answers  

---

How does accounting occured in Expense Reporting?

1 Answers   Sapient,

---

What is profile and what is level of profile option and it's hierarchy

1 Answers   IBM,

---

How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?

2 Answers   Deloitte, Intelligroup,

---

How to print multi currency,multi language in xml?

1 Answers  

---