join mutiple rows into one row if the rows have the same key id .

1) select order_id,wmsys.wm_concat(cc_content) cc_content from t_a1 group by order_id;

 

http://www.itpub.net/thread-1069821-1-1.html

 

http://ms.itpub.net/viewthread.php?tid=1069821&extra=&page=2

 

http://www.huarw.com/db/Oracle/200806/1612972.html