This content has been marked as final.
Show 3 replies
-
1. Re: Row to Column Conversion
Karthick2003 Jun 20, 2013 12:57 PM (in response to 1007945)You could always search the forum. The search feature is very good in the upgraded forum.
-
2. Re: Row to Column Conversion
BluShadow Jun 20, 2013 12:59 PM (in response to 1007945)Or the forum FAQ: Re: 4. How do I convert rows to columns?
Note: DO NOT use the wm_concat function (see the FAQ)
-
3. Re: Row to Column Conversion
Hoek Jun 20, 2013 1:23 PM (in response to 1007945)In addition to Karthick (search is indeed much better!) and Blu (let's hope OP bookmarks the FAQ-link ):
Tim Hall's Oracle-Base is loaded with articles and examples regarding them:
http://www.oracle-base.com/articles/misc/string-aggregation-techniques.php
http://www.oracle-base.com/articles/11g/pivot-and-unpivot-operators-11gr1.php
you can find lots more examples if you search on http://asktom.oracle.com
Keep in mind that aggregating columns <> pivoting
And some more profound explanations: