Answer / 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

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,

---

What is a nested table in word?

1 Answers  

---

Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

---

What is the advantage of nosql?

1 Answers  

---

What are the types of triggers in sql?

1 Answers  

---

What are the different datatypes available in PL/SQL?

1 Answers  

---

What is sql comments?

1 Answers  

---

what is meant by DML?

5 Answers   HCL,

---

How to revise and re-run the last sql command?

1 Answers  

---

why we use nocopy?

2 Answers   Polaris,

---

Does sql support programming?

1 Answers  

---

What is cross join example?

1 Answers  

---