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?
AskTom is the place for stuff like this. e.g. http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:419593546543
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.
Query result always will be displayed row by row.. bcz database created like this..it will be understood by every one..