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 API and Interface?

2 Answers   Infogain,

---

in ap_terms table what data will be stored

2 Answers   Wipro,

---

WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers  

---

What do you understand by concurrent programs?

0 Answers  

---

what is the defference between credit memo and debit memo

2 Answers  

---

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

4 Answers   IBM,

---

Is that Possible To create package Overloading , If Yes Give any Examples

1 Answers   PWC,

---

Can u define operating units inplace of inventory?

2 Answers  

---

in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

2 Answers   Oracle, Schneider,

---

What and Who is the best Institute or Trainer for Oracle Apps Technical ?

2 Answers  

---

In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?

2 Answers  

---

What is the maximum number of statements that can be specified in a trigger statement?

1 Answers   Oracle,

---