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?
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
Is This Answer Correct ? | 1 Yes | 1 No |
How do I save a stored procedure?
what happens if you no create privilege in a database? : Sql dba
Explain aggregate functions are available there in sql?
What is before and after trigger?
display your age in months?
What does select count (*) mean in sql?
How much does sql cost?
What is trigger with example?
What will you get by the cursor attribute sql%found?
How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
Why do we use partitions in sql?
What is record variable?