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
How many sql statements are used? Define them.
how to present a past time in hours, minutes and seconds? : Sql dba
write an sql query to find names of employee start with 'a'? : Sql dba
Is it possible to update views?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
How do I edit a trigger in sql developer?
what is difference between delete and truncate commands? : Sql dba
Is primary key a clustered index?
Which nosql database is best?
Who is the owner of mysql database?
What is the order of sql select?
What are instead of triggers?
Explain character-manipulation functions?
How is use pl and sql?
What is procedure and function in sql?