What are the modes of parameters that can be passed to a
procedure ?
- 3 Answers
- 9381 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 to change the order of columns in Oracle SQL Plus ?
What is nosql db?
How many types of indexes are there in sql?
How exception is different from error?
What are local and global Indexes and where they are useful.
Can you rollback after commit?
What is sap sql?
what tools available for managing mysql server? : Sql dba
Which are sql * plus commands?
What are string functions in sql?
What is cursor status?
What is the least restrictive isolation level? : Transact sql
What is the difference between a primary key and a clustered index?
What is the use of stored procedures?
In a distributed database system, can we execute two queries simultaneously?
