Answer Posted / shekharjchandra

Hope u mean the below question

can we write stored function in out parameters? how to call
through select statement? how to written more than one
value plz give the exmple?

As

can we write stored function in out parameters? how to call
through select statement? how to RETURN more than one
value plz give the exmple?

------
We can write stored function with both IN and OUT parameters.

We can call from select statement only if there is no OUT parameter in it, and that too the called function should not modify the table data what is referred in Select statement.
And other condition it should not return multiple values when it is referred in Select statement

In order to return more then one value you have to use OT parameters or return the value as record and loop through the returned values.

Regards
J

What is a memo field?

698

---

Is like operator in sql case sensitive?

730

---

What are the packages in pl sql?

742

---

Why is sql better than hql?

686

---

Is it possible to read/write files to-and-from PL/SQL?

840

---

---

What are all the different normalizations?

744

---

What is the primary use of normalization?

701

---

What is the non-clustered index in sql?

751

---

Is sql a programming?

716

---

How many databases can sql express handle?

729

---

What is the use of primary key?

731

---

Are stored procedures faster than dynamic sql?

738

---

what is foreign key? : Sql dba

750

---

What is transaction control language (tcl)?

849

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

712

---