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.

Can we use distinct and group by together?

0 Answers  

---

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

---

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

---

Can we join more than 2 tables in sql?

0 Answers  

---

What is the difference between microsoft access and sql?

0 Answers  

---

How many types of privileges are available in sql?

0 Answers  

---

What is sqlca in powerbuilder?

0 Answers  

---

What is exception? What are the types of exceptions?

0 Answers  

---

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

---

What is rank () in sql?

0 Answers  

---

What is count * in sql?

0 Answers  

---

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  

---