tag:blogger.com,1999:blog-2737532577336836817.post5987388787337606021..comments2009-12-01T19:29:24.064ZComments on Lishblog: How to pivot a column to a CSV list in OracleMark Lishmanhttp://www.blogger.com/profile/04691975099200266330mark.lishman@googlemail.comBlogger4125tag:blogger.com,1999:blog-2737532577336836817.post-31481780633494227642009-12-01T19:29:24.086Z2009-12-01T19:29:24.086ZXMLAgg is awesomeXMLAgg is awesomeHittuhttp://www.blogger.com/profile/13549602253930045111noreply@blogger.comtag:blogger.com,1999:blog-2737532577336836817.post-57020816653749477202009-09-28T16:08:13.926+01:002009-09-28T16:08:13.926+01:00or use xmlagg:
1 select deptno, rtrim( xmlagg(...or use xmlagg:<br /><br /> 1 select deptno, rtrim( xmlagg(xmlelement(c, ename || ',') order by ename).extract('//text()'), ',') as employees<br /> 2 from emp<br /> 3* group by deptno<br /> /<br /><br /> DEPTNO EMPLOYEES<br />---------- ------------------------------------------------------------<br /> 10 CLARK,KING,MILLER<br /> 20 ADAMS,FORD,JONES,SCOTT,SMITH<br /> 30 ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARDAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2737532577336836817.post-45340364220417487932009-02-12T20:15:21.410Z2009-02-12T20:15:21.410ZThank you very much!!Thank you very much!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2737532577336836817.post-76035800626424146102009-01-12T19:39:13.362Z2009-01-12T19:39:13.362ZThanks a bunch, chief. You saved me a LOOOOOOOT of...Thanks a bunch, chief. You saved me a LOOOOOOOT of time.Anonymousnoreply@blogger.com