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 is view explain with example?

0 Answers  

---

What is a recursive join sql?

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  

---

How do you create an update query?

0 Answers  

---

---

What is normalization? How many normalization forms are there?

0 Answers  

---

how to get help information from the server? : Sql dba

0 Answers  

---

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---

How do I run a sql query in pgadmin 4?

0 Answers  

---

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 Answers  

---