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

what is denormalization. : Sql dba

1088


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1818


What are the types of triggers in sql?

1067


What is execute immediate?

1068


What is the least restrictive isolation level? : Transact sql

1048


How do you sort in sql?

991


what's the difference between a primary key and a unique key? : Sql dba

1031


What is rollback?

1094


How to display the current date in sql?

1055


What jobs use sql?

967


What are procedures used for?

969


What is the purpose of the primary key?

1050


How do I audit the sql sent to the server?

993


What is sp_helptext?

1052


What language is oracle sql developer?

987