Oracle 分隔符转多行
select to_char(sysdate, 'yyyy') || '-' ||
regexp_substr('06-20;12-20', '[^;]+', 1, level) value
from dual
where 1 = 1
connect by level <= regexp_count('06-20;12-20', '[^;]+')
order by value asc
人生有几个十年呢？点点滴滴，用文字记录
select to_char(sysdate, 'yyyy') || '-' ||
regexp_substr('06-20;12-20', '[^;]+', 1, level) value
from dual
where 1 = 1
connect by level <= regexp_count('06-20;12-20', '[^;]+')
order by value asc
