Answer / amit

In a procedure, we can return a value using OUT PARAMETER
or EVEN USING IN OUT PARAMETER.

For Eg:

CREATE OR REPLACE PROCEDURE add_num(a IN NUMBER, b IN OUT
NUMBER) IS
BEGIN
b:= a + b;
END add_num;

The IN OUT / OUT parameters can be modified within PLSQL
block and the updated values of this parameter can be
refered using a actual paramter once the execution of this
procedure is completed.

Answer / ravindra babu kamma

using out parameter

Answer / veerabhargav reddy

In procedure we can return value using Out Parameter,

Explain the multi-organization structure.

1 Answers   Accenture,

---

What is ment by Global Templates in Oracle.

1 Answers   IBM,

---

what is the diff between custom.pll and form personalization? Tell me one example?

4 Answers   Oracle,

---

Write an SQL Query to Delete Duplicate records from a table using ROWID.

24 Answers   pspl, Satyam, Thinkways,

---

what are the match approvals in PO?

3 Answers  

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

0 Answers   IBM,

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

5 Answers   Wipro,

---

what are the prerequisites for costing transactions?

0 Answers   Scan Steel,

---

Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  

---

Is it possible calling from one report to another? if possible means tell me ?

3 Answers   Intelligroup, Satyam,

---

What are different execution methods of executabls?

1 Answers   Genpact, TCS,

---

What is multi org?

6 Answers   Accenture, CTS,

---