Answer / gireesh.p.v

the modes of parameters passing are 3 type

1) IN
2) OUT
3) INOUT

COMTACT ME gireesh.p.v@gmail.com

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.

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.

What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,

---

How to handle bulk data?

0 Answers  

---

What is the difference between union and union all command?

0 Answers  

---

What is the max nvarchar size?

0 Answers  

---

how to drop an existing index in mysql? : Sql dba

0 Answers  

---

what is the difference between $message and $$message? : Sql dba

0 Answers  

---

What is rank dense_rank and partition in sql?

0 Answers  

---

What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

---

How do I partition in sql?

0 Answers  

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

What is on delete restrict?

0 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---