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
Oracle 分隔符转多行
最新推荐文章于 2023-11-09 10:30:23 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)