Oracle查询任意时间段内的所有日期,无需建表

select  date'2017-04-25' + (rownum - 1)  dt          from  dual connect by rownum <= (date'2017-05-05' - date'2017-04-25' + 1)

运行结果：

2017-04-252017-04-262017-04-oracle账号272017-04-282017-04-292017-04-302017-05-012017-05-022017-05-032017-05-042017-05-05