how do u call in & out parameters for stored procedures?
Answer Posted / susila
create or replace procedure <pocedure_name>(x in number,y
out number) is begin
{
executable statements;
}
end <procedure_name>;
exec <procedure_name>(10,y);
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Why stored procedures are faster than query?
Who is the owner of mysql database?
What are local and global Indexes and where they are useful.
What is rownum in sql?
Can we use threading in pl/sql?
what is a constraint? Tell me about its various levels. : Sql dba
What are instead of triggers?
Is not equal in sql?
What is sql not null constraint?
What are the different tcl commands in sql?
How do I filter in sql profiler?
What port does sql server use?
Are stored procedures faster than queries?
What is dynamic sql in pl sql?
What is pivot table in sql?