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
Why should I use postgresql?
What is varchar example?
What is nvl?
Can we join two tables without common column?
Is and as keyword in pl sql?
What is difference between stored procedures and application procedures?
What is a common use of group by in sql?
Is mariadb nosql?
How is sql used in oracle?
what is “go” in t-sql? : Transact sql
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is insert command in sql?
Does sql view stored data?
How would you pass hints to the sql processor?
how to enter binary numbers in sql statements? : Sql dba