Answer / madhuri

We can call a procedure into another procedure.

create or replace procedure proc1(empno number) is
begin
proc2(20,'CLERK');
end;

When we execute proc1 as follows
exec proc1(7891);

it will execute proc1 and proc2 as well

Answer / swapna

while creating a procedure body we can call other procedure
in that body

for example if your creating the procedure body p1 we can
call the procedure p2 in the procedure body p1

syntax

create or replace procedure p1(a number) is
b number;
begin
p1(10);-- calling first procedure
end;
when you execute procedure p1
exec p1(10) -- it will execute both p1 and p2

What is difference between sql function and stored procedure?

0 Answers  

---

What are local and global variables and their differences?

0 Answers  

---

What does rownum mean in sql?

0 Answers  

---

What is dbo in sql?

0 Answers  

---

what is cross join? : Sql dba

0 Answers  

---

Does sqlite need a server?

0 Answers  

---

what are the types of subquery? : Sql dba

0 Answers  

---

What is the use of sqldataadapter?

0 Answers  

---

List the various privileges that a user can grant to another user?

0 Answers  

---

What is character functions?

0 Answers  

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

---

What is diff between bulk collect and forall

3 Answers   Metric Stream,

---