Oracle 一条数据转成多条

发表于 分类于 
1
2
3
SELECT ROWNUM id
FROM dual
CONNECT BY ROWNUM <= 15
1
2
3
4
5
select to_char(sysdate - r.id, 'yyyy-mm-dd')
  from (SELECT ROWNUM - 1 id
          FROM dual
        CONNECT BY ROWNUM <=
                   floor(sysdate - to_date('20200201', 'yyyymmdd'))) r;