Oracle-使用wmsys.wm_concat把行转换成合并列

wmsys.wm_concat //数据库内部函数：把多行转换成一合并列

例如:

select b.fchannel_id from sinocms_bindle_channel b where b.channel_id='1000000027'

结果：

1 1000000029

2 1000000030

3 1000000031

4 1000000032

5 1000000033

6 1000000034

 

 把多行转换成一合并列

select wmsys.wm_concat(b.fchannel_id) from sinocms_bindle_channel b where b.channel_id='1000000027'

 结果：1000000029,1000000030,1000000031,1000000032,1000000033,1000000034