Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Explain the the delete statements in sql?

983


how to drop an existing view in mysql? : Sql dba

997


How is indexing done in search engines?

930


what are the types of subquery? : Sql dba

1053


Why indexing is needed?

940


What is the use of <> sql?

933


How is data stored on a disk?

965


What is trigger explain it?

966


Why stored procedure is faster than query?

951


What do you mean by rowid?

917


How do you define a foreign key?

941


Is sql a backend?

968


Are null values same as that of zero or a blank space?

969


What is a clob in sql?

969


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3518