只是记录以防忘记
原始数据:
拆分后的数据
with a as
(select t.*, regexp_count(t.str, '[A-Za-z0-9]+') sl from c##lihh.str_slip t),
b as
(select level lvl from dual connect by level <= (select max(a.sl) from a))
select a.*, b.*, regexp_substr(a.str, '[A-Za-z0-9]+', 1, lvl) sub_string
from a, b
where a.sl >= b.lvl
order by 1, 4```