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 is a process of pl/sql compiled?
What does <> sql mean?
What is sql and its types?
How to start the command-line sql*plus?
How is pl sql different from sql?
What is sorting in sql?
Why do we need unique key in a table?
Is postgresql a nosql database?
Define tables and fields in a database
Does inner join return duplicate rows?
How many postgresql users are there, worldwide?
How to use sql statements in pl/sql?
what are aggregate and scalar functions? : Sql dba
Write the command to remove all players named sachin from the players table.
Is hadoop a nosql?