What are the modes of parameters that can be passed to a
procedure ?
Answer Posted / krupakar
Three Types of Parameters.
1) IN parameter mode- This mode is used to pass values to
the calling module when invoked.The value of IN parameter
can't be changed in the module.
2) OUT parameter mode -This mode is used to return a value
to the main block.The value of OUT parameter can change
anywhere in the program.
3)IN OUT parameter mode-This mode is used to pass values to
the calling module and return a value to the main block.The
value of IN OUT parameter can change anywhere in the
program.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Does postgresql run on the cloud?
What is vector point function?
Is it possible to update views?
Can we use joins in subquery?
how to do backup entire database? : Transact sql
Is there any restriction on the use of union in embedded sql?
Explain the types of joins in sql?
What is pl sql block structure?
how to run 'mysql' commands from a batch file? : Sql dba
What is composite primary key in sql?
Explain isolation levels. : Transact sql
What is sql constant?
how do you login to mysql using unix shell? : Sql dba
Can we commit inside a trigger?
Is primary key a clustered index?