select date'2017-04-25' + (rownum - 1) dt
from dual connect by rownum <= (date'2017-05-05' - date'2017-04-25' + 1)
运行结果:
2017-04-25
2017-04-26
2017-04-27
2017-04-28
2017-04-29
2017-04-30
2017-05-01
2017-05-02
2017-05-03
2017-05-04
2017-05-05