行转列函数wm_concat

wm_concat是10G提供的行转列函数

比如

select warehouse_id as wid from table  and rownum <= 6

1               200020

2               200020

3               200020

4               200020

5               200020

6               200020

select wm_concat(warehouse_id) as wid from table and rownum <= 10

1           200020,200020,200020,200020,200020,200020