oracle查询连续的日期

   select to_date('2015-10-01', 'yyyy-mm-dd') + rownum - 1
     from dual
   connect by rownum <= to_date('2015-10-20', 'yyyy-mm-dd') -
              to_date('2015-10-01', 'yyyy-mm-dd') + 1;