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

What is 19 null in sql?

936

---

What is oracle pl sql developer?

963

---

What is sqlite format?

1173

---

Explain the purpose of %type and %rowtype data types?

905

---

What is delete command in sql?

1089

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1144

---

What are the benefits of pl/sql packages?

1090

---

What is the example of procedure?

910

---

What is the best sql course?

971

---

What are all the common sql functions?

999

---

Why is sharding used?

979

---

how to start mysql server? : Sql dba

1182

---

Is a foreign key always unique?

921

---

What is optimistic concurrency control? : Transact sql

971

---

What is a data manipulation language?

1007

---