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

Does user triggers have entry for trigger with compilation errors?

0 Answers  

---

what is the difference difference between procedure and packages

2 Answers   3i Infotech, Oracle,

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

---

What is sql lookup?

0 Answers  

---

How much does sql certification cost?

0 Answers  

---

What is secondary key?

0 Answers  

---

What do you understand by pl/sql packages?

0 Answers  

---

Why query optimization is needed?

0 Answers  

---

How can I tell if sql is running?

0 Answers  

---

Why use subqueries instead of joins?

0 Answers  

---

What is not null in sql?

0 Answers  

---

What are the indexing methods?

0 Answers  

---