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
How many joins can you have in sql?
Why do we create views in sql?
what is sql server agent? : Sql dba
How long it takes to learn pl sql?
What is %type in sql?
How many commands are there in sql?
What is not equal in sql?
What is java sql driver?
What is a loop in sql?
how to drop an existing table in mysql? : Sql dba
What is the difference between view and stored procedure?
What jobs use sql?
what is a record in a database ? : Sql dba
Define select, insert, create, delete, update, drop keywords
Does truncate table reset auto increment?