Oracel拆分逗号隔开的数据为多条
select regexp_substr(q.cs_id, '[^,]+', 1, rownum,'i') from (select * from T_RSGL_FGCS t where t.fgld = '1813') q connect by rownum <= LENGTH(q.cs_id) - LENGTH(REGEXP_REPLACE(q.cs_id, ',', '')) + 1;
select regexp_substr(q.cs_id, '[^,]+', 1, rownum,'i') from (select * from T_RSGL_FGCS t where t.fgld = '1813') q connect by rownum <= LENGTH(q.cs_id) - LENGTH(REGEXP_REPLACE(q.cs_id, ',', '')) + 1;