Oracle中REGEXP_SUBSTR函数(字符串转多行)
SELECT COLUMN_VALUE FROM TABLE(SYS.ODCIVARCHAR2LIST(‘1’,‘2’,‘3’,‘4’,‘5’));
select regexp_substr(‘1,2,3,4,5’,’[^,]+’,1,rownum)
from dual
connect by rownum<=length(‘1,2,3,4,5’)-length(replace(‘1,2,3,4,5’,’,’))+1
Oracle中REGEXP_SUBSTR函数(字符串转多行)
SELECT COLUMN_VALUE FROM TABLE(SYS.ODCIVARCHAR2LIST(‘1’,‘2’,‘3’,‘4’,‘5’));
select regexp_substr(‘1,2,3,4,5’,’[^,]+’,1,rownum)
from dual
connect by rownum<=length(‘1,2,3,4,5’)-length(replace(‘1,2,3,4,5’,’,’))+1