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 commit statement.

1101


what are the advantages and disadvantages of views in a database? : Sql dba

993


What is composite data type in pl sql?

1029


Explain the difference in execution of triggers and stored procedures?

964


What is vector point function?

999


What is the difference between functions, procedures, and packages in pl/sql?

972


Which table is left in left join?

951


What are different methods to trace the pl/sql code?

1046


Do we need commit after truncate?

1025


What company owns postgresql?

960


Can we use pl sql in mysql?

959


What is a temporal data type?

974


What is a primary key sql?

989


How much does a sql dba make? : SQL DBA

888


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1175