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
which types of join is used in sql widely? : Sql dba
How do you copy a table in sql?
what is a trigger? : Sql dba
How do I partition a table in sql?
What is a primary key called that is made up of more than one field?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What pl/sql package consists of?
How to connect a sql*plus session to an oracle server?
What is constant in pl sql?
How can we optimize a sql query?
Explain the significance of the & and && operators in pl sql.
what is user defined functions? : Sql dba
What is sql analyzer?
How do I run a query in pl sql developer?
what are the advantages of mysql in comparison to oracle? : Sql dba