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

explain normalization concept? : Sql dba

0 Answers  

---

Why truncate is used in sql?

0 Answers  

---

What are different methods to trace the pl/sql code?

0 Answers  

---

what are the nonstandard string types? : Sql dba

0 Answers  

---

What is a behavioral trigger?

0 Answers  

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  

---

Can we delete column in sql?

0 Answers  

---

Explain commit, rollback and savepoint.

0 Answers  

---

What are expressions?

0 Answers  

---

Types of joins?

4 Answers   Microsoft,

---

How do I edit a stored procedure?

0 Answers  

---

Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

---