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 will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

---

How do you take the union of two tables in sql?

0 Answers  

---

What is embedded sql what are its advantages?

0 Answers  

---

What is microsoft t sql?

0 Answers  

---

How is pl sql different from sql?

0 Answers  

---

What is clustered and nonclustered index in sql?

0 Answers  

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

Can we write dml inside a function in sql server?

0 Answers  

---

How many clustered indexes can be created on a table?

0 Answers  

---

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

---

Can we join 3 tables in sql?

0 Answers  

---

What is the difference between microsoft sql and mysql?

0 Answers  

---