how do u call in & out parameters for stored procedures?
Answer Posted / sangeetha
create or replace procedure <pocedure_name>(x in number,y
out varchar) is begin
{
executable statements;
}
end <procedure_name>;
exec <procedure_name>(first_parameter,second_parameter);
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is prepared statement in sql?
What is auto increment in sql?
What is rownum and rowid?
Write the command to remove all players named sachin from the players table.
Is sql port 1433 encrypted?
What is join view in sql?
How to start the command-line sql*plus?
Is inner join faster than left join?
what are the different tables present in mysql? : Sql dba
is it possible to pass an object or table to a procedure as an argument?
What is rownum?
Which one is faster ienumerable or iqueryable?
How can get second highest salary in sql?
how to select unique records from a table? : Sql dba
What is the basic structure of an sql?