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 the best free sql database?
How to look at the current sql*plus system settings?
What is dml statement?
What is type and rowtype in pl sql?
Explian rowid, rownum?
What are primary key and foreign key and how they work?
What is sqlcontext?
Why do we use function in pl sql?
Give the order of sql select?
How do I truncate a sql log file?
Which are the different character-manipulation functions in sql?
Why is sql*loader direct path so fast?
How much does sql cost?
What is sql architecture?
Why join is faster than subquery?