oracle 生成一年内的 年 月 日 星期

oracle sql 

select everyDay,to_char(everyday,'yyyy') as 年,
   to_char(everyday,'mm') as 月,
   to_char(everyday,'dd') as 日,
   decode(to_char(everyday,'D')-1,0,7,to_char(everyday,'D')-1) as 星期几,
   lpad(to_char(everyday,'w'),6) as 该月的第几周,
   lpad(to_char(everyday,'ww'),6) as 该年的第几周
   from(select to_date('20180101','yyyymmdd') + level - 1 as everyDay from dual
  connect by level <= 
  (last_day(to_date('20181201','yyyymmdd')) - to_date('20180101','yyyymmdd') +1));