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

Is sql database free?

0 Answers  

---

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

---

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

---

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

---

What is before and after trigger?

0 Answers  

---

What is a mutating table

5 Answers   TCS, Tech Mahindra,

---

there are .......different types of serializability

1 Answers   Wipro,

---

What is cursor in pl sql with examples?

0 Answers  

---

what does myisamchk do? : Sql dba

0 Answers  

---

What is a boolean in sql?

0 Answers  

---

How do I debug a stored procedure?

0 Answers  

---

Does sql require a server?

0 Answers  

---