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

Which sql statement is used to delete data from a database?

1001

---

What are the different types of triggers?

1189

---

What does sign mean sql?

1173

---

What is the starting oracle error number? What is meant by forward declaration in functions?

1039

---

what tools available for managing mysql server? : Sql dba

1125

---

What do you mean by query optimization?

1044

---

Is left join same as inner join?

1211

---

what is a join? : Sql dba

1081

---

explain advantages of innodb over myisam. : Sql dba

1174

---

What is the difference between between and in condition operators?

1063

---

Explain the rollback statement?

1069

---

what is bdb (berkeleydb)? : Sql dba

1085

---

What is the difference between numeric and autonumber?

1035

---

can sql servers linked to other servers like oracle? : Sql dba

1046

---

Is pl sql and postgresql same?

1176

---