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


Please Help Members By Posting Answers For Below Questions

How long it takes to learn pl sql?

533


What is the unique index?

526


What are keys in sql?

551


What pl/sql package consists of?

638


What is a recursive join sql?

597






What is normalisation and its types?

551


What is snowflake sql?

582


How do you exit in sql?

594


How can you fetch first 5 characters of the string?

554


Is drop table faster than truncate?

554


Is sqlite free?

542


what is a constraint? Tell me about its various levels. : Sql dba

564


What is the difference between delete, truncate and drop command?

553


Which command is used to call a stored procedure?

505


What is the difference between database trigger and stored procedure?

558