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.

wht is the use of Xml reports over reports6i?

5 Answers  

---

what is meant by lexical parameter

1 Answers   Wipro,

---

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

---

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

4 Answers  

---

Types of cursors?

3 Answers  

---

How can u find custom top? where its located? How to find custom top in front end?

1 Answers  

---

Oder of firing triggers in form

7 Answers   Oracle, Zensar,

---

Define multi org structure with example(take any businees).

1 Answers   Oracle, Wipro,

---

In Per_all_people_f table what is the significance of '_f ' ?

6 Answers   HCL,

---

what is fiscalcalendar?

3 Answers   CTS,

---

why do we go for oracle apps technical other than sap and other packages?

2 Answers  

---

IN WHICH MODULE THE LEGAL ENTITY COMES?

5 Answers  

---