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
What is a call statement? Explain with an example.
What is the difference between microsoft sql and mysql?
Why function is used in sql?
How do we accept inputs from user during runtime?
How many times can we commit in a loop?
What is difference between procedure and trigger?
What is union and union all keyword in sql and what are their differences?
List out the acid properties and explain?
explain the difference between delete , truncate and drop commands? : Sql dba
What is time based sql injection?
What is scope of pl sql developer in future?
What is difference between stored function and application function?
Can a select statement fire a trigger?
Explain the the update statement in sql?
What are all types of user defined functions?