Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   Transform Data from Multiple rows in a Single Row (http://www.go4expert.com/forums/transform-data-multiple-rows-single-row-t17169/)

nimesh 27Apr2009 12:42

Transform Data from Multiple rows in a Single Row
 
I've a situation where I'm retreiving the data in a subquery, the result for which can be multiple rows and columns.

And I want the result for this sub-query to appear in a single row for the parent query.

E.g. The Result from Subquery
No. - Name
1 - Google
2 - Yahoo
3 - MSN

The transformation for the parent query
List of Names
1 - Google, 2 - Yahoo, 3 - MSN

Can anyone help me on achieving this?

shabbir 27Apr2009 20:34

Re: Transform Data from Multiple rows in a Single Row
 
Why do you need in single line in the parent query because normally queries are always in result set

xpi0t0s 28Apr2009 17:13

Re: Transform Data from Multiple rows in a Single Row
 
AskTom is the place for stuff like this. e.g.
http://asktom.oracle.com/pls/asktom/...D:419593546543

nimesh 29Apr2009 20:25

Re: Transform Data from Multiple rows in a Single Row
 
I know it won't make much sense but the data from subquery can go from 0 to 50 records for each parent query, so to keep it simple and understandable, I want it this way.

Thanks xpi0t0s for reminding about AskTom and giving the correct thread link.

sudhagar 6Apr2010 17:40

Re: Transform Data from Multiple rows in a Single Row
 
Query result always will be displayed row by row..
bcz database created like this..it will be understood by every one..


All times are GMT +5.5. The time now is 17:56.