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 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
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the qualities of 2nf?
What is a sql*loader control file?
What are transaction and its controls?
What are different types of keys?
How do I run a script in sql developer?
What is difference between procedure and trigger?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What is the best sql course?
State few characteristics of pl/sql?
What version is sql?
What is the difference between nested table and varray?
What is the best free sql database?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What does an inner join do?
What are sql triggers used for?