Interested to Buy Any Domain ? << Click Here >> for more details...
can we call a procedure into another procedure?If yes means
how you can pass the perameters for the two procedures?
- 2 Answers
- 13369 Views
- Fujitsu, I also Faced
- E-Mail Answers
Answer Posted / 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 This Answer Correct ? | 9 Yes | 9 No |
Post New Answer View All Answers
What is over () in sql?
What is sql trigger example?
what are date and time intervals? : Sql dba
what is a database? : Sql dba
What is a loop in sql?
What are % type and % rowtype?
What are the advantages of pl sql over sql?
How does join work in sql?
Which command is used to call a stored procedure?
How do I get sql certification?
What is a sql select statement?
How do I remove sql plus from windows 10?
What are the types of variables use in pl sql?
Where is sql database stored?
explain the difference between bool, tinyint and bit. : Sql dba
