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
What is delimiter sql?
Explain the components of sql?
what is clause? : Sql dba
In what condition is it good to disable a trigger?
Is delete faster than truncate?
How to fix oracle error ora-00942: table or view does not exist
What is an ndf file?
What is the difference between joins?
How do you clear the screen in sql?
Is sql better than excel?
What is the purpose of normalization?
What is the purpose of design view?
how to create a new view in mysql? : Sql dba
What is normalization in a database?
When is the update_statistics command used?