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 exit statement?

1001

---

What are joins in sql?

1028

---

How to display the records between two range in Oracle SQL Plus?

1134

---

Explain what is rdbms?

1018

---

What is the best partition size for windows 10?

986

---

Is and as keyword in pl sql?

943

---

what is cursor. write example of it. What are the attributes of cursor.

1366

---

What is the maximum number of rows in sql table?

1008

---

What are the various levels of constraints?

1114

---

What is trigger in pl sql with examples?

1016

---

how to shutdown mysql server? : Sql dba

1082

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1166

---

How would you pass hints to the sql processor?

968

---

What is a sql driver?

985

---

Can I join the same table twice?

1032

---