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 can a process be deployed in soa?

1250

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2103

---

What are the different components you should consider while defining a responsibility in oracle apps?

1072

---

What do you understand by soa and what are the benefits of using this architecture?

1076

---

tell me the scenarios of the independent in reports

2619

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1118

---

How can you achieve loose coupling in soa framework?

1216

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2123

---

What is count(*) from po_vendors(any table)?

1080

---

How is choreography different from orchestration?

1128

---

What is sca and how is it useful?

1121

---

Are you familiar with internet architecture of oracle apps 11i?

1061

---

testing tools?

2248

---

How do you register report in oracle apps?

1096

---

What do you understand by soa?

1154

---