123,abc,opq 转变为
123 1
abc 2
opq 3
select regexp_substr('123,abc,opq', '[^,]+', 1, level) a, level
from dual
connect by level <=
length('123,abc,opq') - length(replace('123,abc,opq', ',')) + 1
123,abc,opq 转变为
123 1
abc 2
opq 3
select regexp_substr('123,abc,opq', '[^,]+', 1, level) a, level
from dual
connect by level <=
length('123,abc,opq') - length(replace('123,abc,opq', ',')) + 1