oracle统计每月数据量 没有月份返回0

补充1到12月表

 with temps as (select lpad(level, 2, 0) as mon from dual connect by level < 13)
    select decode(t.mon,
	               '01',
	               '一月',
	               '02',
	               '二月',
	               '03',
	               '三月',
	               '04',
	               '四月',
	               '05',
	               '五月',
	               '06',
	               '六月',
	               '07',
	               '七月',
	               '08',
	               '八月',
	               '09',
	               '九月',
	               '10',
	               '十月',
	               '11',
	               '十一月',
	               '12',
	               '十二月') as mon,
	               count(to_char(t1.item_time, 'yyyy-mm')) as num
	   from temps t
	   left join site_c_menu_info t1
	   on t.mon = to_char(t1.item_time, 'mm')
	   and to_char(t1.item_time(+), 'yyyy') = #{year,jdbcType=VARCHAR} 
	  group by t.mon
	  order by t.mon