oracle列出两个日期间所有日期

 

select date '2010-1-1'+level-1 dates
from dual
connect by level <date '2010-1-10' -date '2010-1-1'+2
order by dates;