ORACLE查询任意时间段的的日期集合

1、这条sql语句查询出来的将会是2015-01-01至2016-09-01'所有的月份。

select to_char(dt, 'yyyy/MM') as dat
  from (select date '2015-01-01' + (rownum - 1) dt
          from dual
        connect by rownum <= (date '2016-09-01' - date '2015-01-01' + 1))

 group by to_char(dt, 'yyyy/MM') order by dat;

2、这条语句查询出来的是日期范围内的所有天数

select date '2015-01-01' + (rownum - 1) dt

          from dual
        connect by rownum <= (date '2016-09-01' - date '2015-01-01' + 1)

这都是从网上看到的，希望能对别人有用！