select distinct t.id, REGEXP_SUBSTR(t.name ,'[^,]+',1,le) g from cc_test t ,(SELECT LEVEL le FROM DUAL CONNECT BY LEVEL<=25)
where le(+) <= (length(t.name) - length(replace(t.name,',','')) + 1)
and t.name is not null
Oracle 中对字符串数据进行逗号拆分
最新推荐文章于 2024-06-25 17:19:55 发布