字段拆分:REGEXP_SUBSTR:select a.* , REGEXP_SUBSTR(a.aa ,'[^,]+',1,l) AS rolecode ,cc/LENGTH(REPLACE(aa,',')) from ANE_AAA a,(SELECT LEVEL l FROM DUAL CONNECT BY LEVEL<=100) b WHERE l <=LENGTH(a.aa) - LENGTH(REPLACE(aa,','))+1
字段合并select p.sequen,(select replace(wm_concat(pa.personname || pa.sequen),',','</br>') from info_pnr_passenger pa where pa.info_pnr = p.sequen)from Info_Pnr p