利用oracle生成年历

with x as(select 
   to_char(everyday,'yyyy-mm') as ym,
   to_char(everyday,'yyyy') as year,
   to_char(everyday,'mm') as month,
   case 
    when to_char(everyday,'mm')='01' and to_char(everyday,'iw')='53' and to_char(everyday,'dy')!='星期日' then 0
    when to_char(everyday,'mm')='01' and to_char(everyday,'iw')='53' and to_char(everyday,'dy')='星期日' and to_char(everyday,'dd')='01' then 0
    when to_char(everyday,'mm')='01' and to_char(everyday,'iw')='53' and to_char(everyday,'dy')='星期日' then 1
    when to_char(everyday,'mm')='01' and to_char(everyday,'iw')='52' then 1
    when to_char(everyday,'mmdd')!='0101' and to_char(everyday,'dy