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

What is the difference between the sql*loader and import utilities? : aql loader

1037

---

What makes a good primary key?

1034

---

Can two tables have same primary key?

971

---

How does one load ebcdic data? : aql loader

1167

---

What pl/sql package consists of?

1079

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1580

---

When is the explicit cursor used ?

1031

---

How do I view a procedure in sql?

966

---

What are all the different normalizations?

1025

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2217

---

Why is nosql good?

1023

---

What is normalization sql?

1051

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1012

---

What view means?

975

---

what is 'trigger' in sql? : Sql dba

1082

---