首先来看一下我们需要的效果:
select '2020,2019,2018,2017' year from dual
使用 regexp_substr 函数:
select regexp_substr('2020,2019,2018,2017', '[^,]+', 1, level) year from dual
connect by level <= (regexp_count('2020,2019,2018,2017', '\,')+1)
sql 解析:
函数1:regexp_substr('2020,2019,2018,2017', '[^,]+'