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
Is it mandatory for the primary key to be given a value when a new record is inserted?
What does plv msg allows you to do?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
How do I count rows in sql query?
What is query execution plan in sql?
What are different types of statements supported by sql?
Can we use rowid as primary key?
How many sql commands are there?
What is sqlcommand?
What is crud stand for?
What are dml commands?
Can you have more than one key in a database?
How to assign sql query results to pl sql variables?
What is a function in oracle pl sql?
what is a database transaction? : Sql dba