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
- 13091 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 a natural join?
What is data type in database?
Explain foreign key in sql?
what are all the different types of indexes? : Sql dba
Which join is like an inner join?
what is user defined functions? : Sql dba
how to start mysql server? : Sql dba
What is an example of translating a date into julian format?
What is trigger explain it?
What is the difference between left join and right join?
What is sqlexception in java?
How can you fetch first 5 characters of the string?
Is hadoop a nosql?
What is the example of procedure?
what are numeric data types? : Sql dba
