Answer / som

1. Declare a variable as the datatype of the out parameter
of the inner procedure.
2. Call the inner procedure with the input/output
parameters- input parameter values and output parametr as
the variable declared.
3. After the inner procedure gets executed, the output
parameter will be accessible to the outer procedure.

Answer / s.syam sundar

first declare a variable globaly
and next create inner procedure with in(if need or u can
set defult parameters) and out parameters
and next result of inner procedure is assigned to global
variable
and next in outer procedure u can get the result from global
variable

regads
S.syam sundar

How to run pl/sql statements in sql*plus?

0 Answers  

---

What is data type in sql?

0 Answers  

---

What is Overloading of procedures ?

2 Answers  

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  

---

How do you retrieve the second highest salary from a table?

3 Answers  

---

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

What is the location of pre_defined_functions.

0 Answers  

---

What are triggers and its uses?

0 Answers  

---

How do I run a sql query?

0 Answers  

---

What is the difference between a query and a report?

0 Answers  

---

What is sql procedures and functions?

0 Answers  

---