变换组合函数wm_concat

转换组合函数wm_concat
Oracle10g以上的版本中提供了转换组合函数。
例如表test_t的原始数据查询结果为:

select * from latty.test_t12004055761G7393344.0422004055761J5667089.8532004055762G6315075.9642004055762J6328716.1552004055763G7393344.0462004055763J5667089.8572004055764G6028670.4582004055764J6459121.4992004055765G13156065.77102004055765J11901671.70112004065761G7614587.96122004065761J5704343.05132004065762G6556992.60142004065762J6238068.05152004065763G7614587.96162004065763J5704343.05172004065764G6387706.01182004065764J6907481.66192004065765G13562968.81202004065765J12495492.50212004075761G7987050.65222004075761J5723215.28232004075762G6833096.68242004075762J6391201.44252004075763G7987050.65262004075763J5723215.28272004075764G6456433.23282004075764J6987660.53292004075765G14000101.20302004075765J12301780.20312004085761G8085170.84322004085761J6050611.37332004085762G6854584.22342004085762J6521884.50352004085763G8085170.84362004085763J6050611.37372004085764G6587559.23

 select wm_concat(area_code) 用户名  from latty.test_t group by bill_month;

15761,5761,5762,5763,5764,5765,5765,5764,5763,576225761,5762,5763,5764,5765,5765,5764,5763,5762,576135761,5764,5765,5765,5764,5763,5761,5762,5763,576245761,5762,5762,5763,5764,5763,5761