--返回指定日期段的日期列表 select to_date('2018-03-01','yyyy-mm-dd') +rownum-1 as rq from dual connect by rownum <=to_date('2018-03-04','yyyy-mm-dd')+1-to_date('2018-03-01','yyyy-mm-dd')