Oracle 表操作之合并多行成一行（ listagg within group 、wmsys.wm_concat）

一、查询语法: select column1,listagg(column2,',') within group (orderby column3) as column4... from tableName1

注意：oracle11g以上才支持此查法     

1.listagg例子：

   select senc_orgid ,senc_orgname,securname,securid ,depusecurname,depusecurid ,commebname,commebid, securlevname, depusecurlevname from (  

        select orgT.senc_orgid ,orgT.senc_orgname,count(senc_orgid) brannum from ( 
          select t1.id senc_orgid,t1.org_name senc_orgname,t3.id thrd_orgid , t3.thrd_orgname from t_Pb_Organization t1 ,( select t2.id,t2.org_name thrd_orgname ,t2.pid from t_Pb_Organization t2 )  t3   where (t1.id=t3.pid  or (t1.id=t3.id and t1.pid=2)  ) and t1.pid !=0 and t1.isdeleted='0' order by t3.id 
        )