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

How to set up sql*plus output format in oracle?

1038

---

what is sql server agent? : Sql dba

1109

---

How to download oracle sql developer?

1110

---

What are some predefined exceptions in pl/sql?

1167

---

how to convert numeric values to character strings? : Sql dba

1107

---

Is sql harder than python?

1108

---

What is the usage of sql functions?

1146

---

What does truncate mean in sql?

1025

---

how to enter numeric values as hex numbers? : Sql dba

1064

---

What is trigger in sql and its types?

1058

---

Which data type is a composite type?

989

---

Can you load data into multiple tables at once? : aql loader

1066

---

what is data manipulation language? : Sql dba

1020

---

What is information schema in sql?

1070

---

what is not null constraint? : Sql dba

1030

---