will function return more than one value how

Answer Posted / chaitra

A function can return more than one value if the function
is returning a data structure like PL/SQL Table, REF CURSOR
etc.
But returning more than one value by the use of OUT
parameter cannot be done as this fails when the function is
called from an SQL statement ( as in where var = fn(..)).

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between mdf and ndf files?

670


What is the difference between distinct and unique in sql?

550


What are the qualities of 2nf?

644


What is embedded sql with example?

645


what is the difference between cluster and non cluster index? : Sql dba

635






Does sql support programming?

654


how is myisam table stored? : Sql dba

685


How to create an array in pl/sql?

668


what is an extent ? : Sql dba

669


what is datawarehouse? : Sql dba

660


What is the plv (pl/vision) package offers?

722


Can I join the same table twice?

637


What is difference between procedure and trigger?

603


What type of database is cloud sql?

666


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

667