What are the modes of parameters that can be passed to a
procedure ?
Answer Posted / suman
IN- The parameter can be referenced by the procedure or
function. The value of the parameter can not be overwritten
by the procedure or function.
OUT- The parameter cannot be referenced by the procedure or
function. The value of the parameter can be overwritten by
the procedure or function.
INOUT- The parameter can be referenced by the procedure or
function. The value of the parameter can be overwritten by
the procedure or function.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to run sql*plus commands in sql developer?
What are the differences between in and exists clause?
What do you mean by dbms? What are its different types?
What is implicit cursor in pl sql?
How many types of tables are there?
Explain the difference between rename and alias?
What is gpt format?
What is difference between hql and sql?
what is sql profiler? : Sql dba
Is left join inner or outer?
How can triggers be used for the table auditing?
Why is sql*loader direct path so fast?
What do you know by pl/sql cursors?
What is pl sql architecture?
How can you load multi line records? : aql loader