ORACLE SQL 无表查询日期

方案一：/* Formatted on 2018/3/30 14:44:04 (QP5 v5.252.13127.32867) */
SELECT ROWNUM, TRUNC (SYSDATE, 'mm') + ROWNUM - 1 AS SHOW_TIME
  FROM (    SELECT *
              FROM DUAL
        CONNECT BY ROWNUM < 99999)
 WHERE ROWNUM <

          TRUNC (ADD_MONTHS (SYSDATE, 1), 'MM') - TRUNC (SYSDATE, 'mm') + 1;

方案二： /* Formatted on 2018/3/30 14:48:46 (QP5 v5.252.13127.32867) */
    SELECT DATE '2017-04-25' + (ROWNUM - 1) dt
      FROM DUAL
CONNECT BY ROWNUM <= (DATE '2017-05-05' - DATE '2017-04-25' + 1);