What are the modes of parameters that can be passed to a
procedure ?
Answers were Sorted based on User's Feedback
the modes of parameters passing are 3 type
1) IN
2) OUT
3) INOUT
COMTACT ME gireesh.p.v@gmail.com
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / suman
IN- The parameter can be referenced by the procedure or
function. The value of the parameter can not be overwritten
by the procedure or function.
OUT- The parameter cannot be referenced by the procedure or
function. The value of the parameter can be overwritten by
the procedure or function.
INOUT- The parameter can be referenced by the procedure or
function. The value of the parameter can be overwritten by
the procedure or function.
| Is This Answer Correct ? | 2 Yes | 1 No |
What types of commands can be executed in sql*plus?
Can you selectively load only those records that you need? : aql loader
how to install mysql? : Sql dba
what is difference between delete and truncate commands? : Sql dba
What is sql query limit?
What are user defined stored procedures ?
What are the advantages of sql? Explain
What are the ways on commenting in a pl/sql code?
How is a PL/SQL code compiled?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
How do you exit in sql?
What is Temp Table and type of temp table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)