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 are the different components you should consider while defining a responsibility in oracle apps?

0 Answers  

---

After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers   HCL,

---

what is the difference between request group and request security in oracle apps?

1 Answers  

---

What are the files we submit while your program move to testing instance?

4 Answers   Cap Gemini,

---

In sequence i want to 11 and 15th values how we will write?

0 Answers  

---

In what situation u create the BPA.

2 Answers   Accenture,

---

differentiate between intra & inter UOM class conversion with examples.

1 Answers   Scan Steel,

---

In hierarchical structure of a database? we have write query from where we should start?

0 Answers   IBM,

---

what is organization id

3 Answers  

---

Do you know where we can check the status of po?

0 Answers  

---

HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,

---

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,

---