What are the modes of parameters that can be passed to a
procedure ?
- 3 Answers
- 8876 Views
- I also Faced
- E-Mail Answers
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
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What can sql server reporting services do?
Can you skip header records while loading? : aql loader
What is nosql db?
What is aggregate function in sql?
What is interval partition?
How to install oracle sql developer?
Why query optimization is needed?
What is a temporal data type?
What are procedures used for?
What is orm in sql?
What is sqlca in powerbuilder?
How to create an array in pl/sql?
What is pl sql collection?
Is keyword pl sql?
