如：
select u_id, to_char(wmsys.wm_concat(name ) ) as name from thomas group by charge_code
select u_id, to_char(wmsys.wm_concat(distinct name ) ) as name from thomas group by charge_code
上面需要注意的点事用to_char()转一下，不然返回的就是clob类型的结果，不够直观
select u_id, wmsys.wm_concat(name || ‘(‘ || num || ‘斤)‘ ) as name from shopping group by u_id
结果显示为
上面charge_code为2的时，有两个梨子，如何实现 梨子（11）呢？
原文：https://www.cnblogs.com/thomasbc/p/12470079.html