wmsys.wm_concat(to_char(b.fieldname)) 行转列函数示例

 select A.*,B.DISPLAYFIELDS from GOODSTRACKFIELDCONFIG A left join
            (select a.ID,wmsys.wm_concat(to_char(b.fieldname)) DISPLAYFIELDS  from GOODSTRACKFIELDCONFIG a left join GOODSTRACKFIELDCONFIGDETAIL  b
            on b.goodstrackfieldconfigid=a.id
            group by A.id ) B  on A.Id=b.id  where 1=1

1  注意 加to_char() 否则中文会乱码

2  注意和group by 配合使用 特别是当多表联合查询的时候