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
What are different types of keys?
How to move files from one directory to another in pl sql?
how to rename an existing column in a table? : Sql dba
How do I run pl sql in sql developer?
How to convert comma separated string to array in pl/sql?
What is the size of partition table?
Why is the cursor important?
What is multiple columns?
How to make a copy values from one column to another in sql?
how to use myisamchk to check or repair myisam tables? : Sql dba
Explain the working of foreign key?
What are the events on which a database trigger can be based?
How do you optimize a stored procedure query?
Differentiate between pl/sql and sql?
What is a table partition?