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
How many tables can a sql database have?
Are null values same as that of zero or a blank space?
What is sql*loader and what is it used for?
What are the set operators in sql?
Explain alias in sql?
how to convert character strings to numeric values? : Sql dba
How many sql statements are used?
What is delimiter sql?
How do I view tables in sql developer?
What are the types of operators available in sql?
How do I find duplicates in two columns?
describe mysql connection using mysql binary. : Sql dba
What is indexing oracle sql?
What is raw datatype in sql?
Can we use two order by clause in query?