SELECT REGEXP_SUBSTR (‘aaaa,bbbb,cccc’, ‘[^,]+’, 1,rownum)
from dual connect by rownum<=LENGTH (‘aaaa,bbbb,cccc’) - LENGTH (regexp_replace(‘aaaa,bbbb,cccc’, ‘,’, ‘’))+1;
Oracle 将字符串分割为多行
最新推荐文章于 2022-06-24 12:32:11 发布
SELECT REGEXP_SUBSTR (‘aaaa,bbbb,cccc’, ‘[^,]+’, 1,rownum)
from dual connect by rownum<=LENGTH (‘aaaa,bbbb,cccc’) - LENGTH (regexp_replace(‘aaaa,bbbb,cccc’, ‘,’, ‘’))+1;