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