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

What is snowflake sql?

800


What can you do with pl sql?

769


What are the operators used in select statements?

771


What is java sql drivermanager?

746


How do I order columns in sql?

699






How do you change a value in sql?

738


What are different joins used in sql?

728


Write a sql select query that only returns each name only once from a table?

757


How to select unique records from a table?

762


What is procedure explain with example?

704


discuss about myisam key cache. : Sql dba

763


What is set serveroutput on?

843


what is a control file ? : Sql dba

759


Explain what is sql*plus?

855


Is sqlite free?

718