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 is the difference between credit memo and debit memo?...

2 Answers   Sony,

---

What is secuirity's in R12 features.

1 Answers   KPIT,

---

List the types of flexfield?

0 Answers  

---

What are basic steps for AIM?

2 Answers  

---

wheather discard file is automatically created or explicty created?can u mention it?

1 Answers   CTS,

---

What is P2P cycle.

27 Answers   Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,

---

whats the use of after parameter form and before report?

2 Answers   IBM,

---

what is the need of registering table in apps?

5 Answers   TCS,

---

we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?

4 Answers  

---

What is responsibility?

5 Answers  

---

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

0 Answers  

---

What is Formula Column?

4 Answers  

---