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;

 

posted on 2022-08-09 15:03  IT-QI  阅读(15)  评论(0编辑  收藏  举报