oracle 10g:select a,wmsys.wm_concat(b) b from (select 1 a,字段名 b from tb) group by a;
select wmsys.wm_concat(colname) from tabname;
select substr(max(sys_connect_by_path(colname,',')),2) arr from ( select colname,row_number() over(order by colname) rn from tabname ) start with rn=1 connect by rn-1=prior rnoracle9i
from
(select 1 a,字段名 b from tb)
group by a;
select substr(max(sys_connect_by_path(colname,',')),2) arr
from (
select colname,row_number() over(order by colname) rn
from tabname
)
start with rn=1
connect by rn-1=prior rnoracle9i