Answer Posted / 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;

How do you register report in oracle apps?

1099

---

tell me the scenarios of the independent in reports

2503

---

What are the benefits of using soa architecture?

1252

---

What are the different components of soa suite?

1209

---

Tell me where we find the status of order information?

1140

---

tell me the scenarios of the independent in reports

2626

---

Do you know what is applysys in oracle application database schema, what is apps?

1179

---

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

2248

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2634

---

what is pay run id ?

2196

---

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

3035

---

Tell me how to debug the report?

1125

---

Explain what are the tables of auto invoice?

1142

---

What is oracle soa suite?

1242

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2616

---