一个sql的应用(加入行,并分解字段)

select t.id,substr(t.uids,instr(t.uids,',',rownum,rownum)+1,3) from TEST11 t connect by rownum<=3;

//用正则
select t.id,
       dbms_lob.substr(regexp_substr(t.uids, '[^,]+', 1, x.n)) as uids
  from TTTTTT t,
       (select rownum n
          from dual
        connect by rownum <
                   (select length(f.uids) - length(replace(f.uids, ',', '')) + 2 n
                      from TTTTTT f)) x