也是纵横转换的问题。
导出的时候再都用竖线|分割,就PDPID,APN各一列了,并且其它APN可以扩展…
select A.MSISDN,APN4.APN1,APN4.APN2,APN4.APN3,APN4.APN4,APNOther.APNS
from XHWHB_2101_MAIN a,
(select IMSI,LISTAGG(PDPID||'|'||APN, '|') WITHIN GROUP(ORDER BY PDPID) APNS from XHWHB_2101_PDP where PDPID not in (1,2,3,4) group by IMSI) APNOther,
(select IMSI,Max(decode(PDPID, '1',PDPID||'|'||APN,null)) APN1,Max(decode(PDPID, '2',PDPID||'|'||APN,null)) APN2,Max(decode(PDPID, '3',PDPID||'|'||APN,null)) APN3,Max(decode(PDPID, '4',PDPID||'|'||APN,null)) APN4 from XHWHB_2101_PDP group by imsi) APN4
where (A.NAM=0 OR A.NAM=2) and A.IMSI=APNOther.IMSI(+) and A.IMSI=APN4.IMSI(+)