/* 查询2013-11-25至2014-12-28内所有日期天数 */
select 
   date '2013-11-25' + (rownum - 1) dt  
from  dual connect by rownum <= (date '2014-12-28' - date '2013-11-25' + 1)