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 are pl/sql exceptions? Tell me any three.

1 Answers  

---

Does user triggers have entry for trigger with compilation errors?

0 Answers  

---

Which version of sql do I have?

0 Answers  

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

how to drop an existing index in mysql? : Sql dba

0 Answers  

---

Types of backups ?

3 Answers   TCS,

---

What is a Mapplet?

0 Answers   Informatica,

---

What is user define exception and example

1 Answers   HP, KP,

---

Can you inner join the same table?

0 Answers  

---

What is the importance of sqlcode and sqlerrm?

0 Answers  

---

How would you hide a table in sql. ie the table can be only visible to its maker?

3 Answers  

---

List different type of expressions with the example.

0 Answers  

---