--Select Rownum, (开始日期)+Rownum-1 from dual connect by rownum< (结束日期-开始日期) +2
Select Rownum, (to_date('2014-03-20','yyyy-mm-dd'))+Rownum-1 from dual connect by rownum< to_date('2014-03-25','yyyy-mm-dd')-to_date('2014-03-20','yyyy-mm-dd') +2;
*若开始、结束日期为日期格式,则不需要转换