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

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

Is grant a ddl statement?

0 Answers  

---

State the advatage and disadvantage of Cursor's?

2 Answers  

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

what the meaning of sql

8 Answers  

---

what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,

---

what are the different index configurations a table can have? : Sql dba

0 Answers  

---

Can sql function call stored procedure?

0 Answers  

---

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

---

Is a table valued function object?

0 Answers  

---

Which normal form is best?

0 Answers  

---

how many columns can be used for creating index? : Sql dba

0 Answers  

---