Oracle使用SQL语句生成连续日期

SELECT to_char(tmp_date,
               'YYYYMMDD') AS date_number,
       to_char(tmp_date,
               'YYYY-MM-DD') AS full_date
FROM   (SELECT LEVEL n,
               to_date('2012-12-30',
                       'YYYY-MM-DD') +
               numtodsinterval(LEVEL,
                               'day') tmp_date
        FROM   dual
        CONNECT BY LEVEL <= 400);

参考