罗列整一年的日期

select to_char(everyday,'yyyy-mm-dd')  from (
select to_date('20100101','yyyymmdd') + level - 1 as everyDay from dual
connect by level <=
(last_day(to_date('20101231','yyyymmdd')) - to_date('20100101','yyyymmdd') +1));