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 language is oracle sql developer?
What is the process of debugging?
Why coalesce is used in sql?
What are inner and outer joins examples of both?
What does the acronym acid stand for in database management?
How is pl sql different from sql?
What is a natural join?
Can a view be mutating? If yes, then how?
What is ttitle and btitle?
How do I create a memory optimized filegroup?
What is the left table in sql?
how do you control the max size of a heap table? : Sql dba
How to look at the current sql*plus system settings?
Can you have a foreign key without a primary key?
Why self join is used in sql?