Interested to Buy Any Domain ? << Click Here >> for more details...
What are the modes of parameters that can be passed to a
procedure ?
- 3 Answers
- 10355 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
How do I remove sql developer from windows 10?
how do you tune the slow running queries in oracle db , explain the methodology
What are %type and %rowtype for?
how to add a new column to an existing table in mysql? : Sql dba
What are aggregate and scalar functions?
What is nvl?
Can we use pl sql in sql server?
What are primary key and foreign key and how they work?
What is the difference between join and natural join?
How many tables can you join in sql?
Are null values same as that of zero or a blank space?
How many types of tables are there?
How many types of relationship are there?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is pl sql quora?
