oracle 拆分字符串为多行

方法1

SELECT
  A.*,
  REGEXP_SUBSTR( A.xxm, '[^,]+', 1, L ) AS L2UNIT_NAME_B,
  L 
FROM
  t_lxcj_jzgbgddxx A,
  ( SELECT LEVEL L FROM DUAL CONNECT BY LEVEL <= 100 ) 
WHERE
  L ( + ) <= LENGTH( A.xxm ) - LENGTH( REPLACE ( A.xxm, ',' ) ) + 1 
ORDER BY
  xh
  

 
  方法2

begin
FOR X IN REVERSE 1 .. 10 LOOP 

insert into T_CORE(wid,name)
  select wid,substr(t,1,instr(t,',',1)-1) from (
select wid,substr(s,instr(s,',',1,rownum)+1)||',' as t,rownum as d ,instr(s,',',1,rownum)+1 from (
select wid,'aaa,bbb'as s from dual where wid =wf
)connect by instr(s,',','1',rownum)>1) yy 
  end loop;
end;