SELECT REGEXP_SUBSTR (‘1,2,3,4’, '[^,]+', 1,ROWNUM)
FROM tablename
CONNECT BY ROWNUM <=
LENGTH (‘1,2,3,4’) - LENGTH (REPLACE (‘1,2,3,4’, ',','')) + 1
该语句执行后会得到一个临时表,将字段值拆分后写到多个行中。
SELECT REGEXP_SUBSTR (‘1,2,3,4’, '[^,]+', 1,ROWNUM)
FROM tablename
CONNECT BY ROWNUM <=
LENGTH (‘1,2,3,4’) - LENGTH (REPLACE (‘1,2,3,4’, ',','')) + 1
该语句执行后会得到一个临时表,将字段值拆分后写到多个行中。