源表:chq3g4
输出:
语句:
with recursive
func(f, smcl_num) as (select part, length(part) - length(replace(part, ';', ''))
from chq3g4
union
select ltrim(ltrim(f, substr(f, 1, instr(f, ';') - 1)), ';'), smcl_num - 1
from func
where smcl_num > 0),
detail as (select case
when instr(f, ';') = 0 then f
else substr(f, 1, instr(f, ';') - 1)
end col1
from func)
select *
from detail;