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

How does sql*loader handles newline characters in a record? : aql loader

1041


How many indexes can be created on a table in sql?

1045


What is trigger and how to use it in sql?

1021


How do I make my sql query run faster?

939


How many sql core licenses do I need?

944


Explain the uses of control file.

1046


Is natural join same as inner join?

926


What are the indexing methods?

1039


How can you select unique records from a table?

1069


Why we use stored procedure instead of query?

997


How many sql statements are used? Define them.

1035


What is foreign key sql?

983


what are the disadvantages of mysql? : Sql dba

1144


How can we avoid duplicating records in a query?

975


How do I tune a sql query?

968