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 join? : Sql dba
What is difference between inner join and self join?
What does the sign mean in sql?
Can we use delete in merge statement?
What does the hierarchical profiler does?
What is rownum?
how to delete an existing column in a table? : Sql dba
define join and explain different type of joins? : Sql dba
What is data types in sql?
What is difference between sql function and stored procedure?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is the purpose of my sql?
what is offset-fetch filter in tsql? : Transact sql
write an sql query to find names of employee start with 'a'? : Sql dba
What is a call statement? Explain with an example.