Oracle 一条数据转成多条

发表于 2019-11-21 分类于 Database

1
2
3

SELECT ROWNUM id
FROM dual
CONNECT BY ROWNUM <= 15

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;