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

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2 Answers  

---

what is the difference between undefined value and null value? : Sql dba

0 Answers  

---

What is equi join in sql?

0 Answers  

---

What is different between union and minus?

7 Answers   Accenture, TCS,

---

Why do we use procedures in sql?

0 Answers  

---

what is the difference between delete and truncate commands? : Sql dba

0 Answers  

---

what are the types of subquery? : Sql dba

0 Answers  

---

What is the use of & in pl sql?

0 Answers  

---

differentiate between float and double. : Sql dba

0 Answers  

---

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

---

Explain two easy sql optimizations.

0 Answers  

---

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---