SELECT REGEXP_SUBSTR ('123,456,789', '[^,]+', 1,rownum) from dual connect by rownum<=LENGTH ('123,456,789') - LENGTH (regexp_replace('123,456,789', ',', ''))+1
oracle 字符串转字符串组sql
于 2022-03-14 10:47:18 首次发布
SELECT REGEXP_SUBSTR ('123,456,789', '[^,]+', 1,rownum) from dual connect by rownum<=LENGTH ('123,456,789') - LENGTH (regexp_replace('123,456,789', ',', ''))+1