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 difference between d2k report and oracle apps report

10 Answers   Seven Hills, Wipro,

---

what is item status? name the related table.

1 Answers   Scan Steel,

---

what is mutating table and mutating error and how to solve that?

3 Answers  

---

can we use commit in trigger? If yes how?

2 Answers   Cap Gemini, TCS,

---

how can we return morethan one parameters in procedure?

2 Answers  

---

what is the difference between procedure and function

3 Answers   Wipro,

---

what are the different transaction clauses in AR?

0 Answers   BirlaSoft,

---

we have 4 managers if one person logon the system automatically displays his siganature and name how?

1 Answers   BirlaSoft,

---

How can u populate data into po_headers_all segment2 column?

1 Answers   BirlaSoft,

---

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

9 Answers   TCS,

---

why r u transer the data base tables to flat file and what is use

2 Answers  

---

please send me forms, xml pulisher questions,answers

0 Answers   Zensar,

---