oracle选择日期范围内每天的统计

oracle每天的统计语句

select  nvl(count(t.id),0) as dayCount,d.dt as everyDay
     from table_name t
     right join (select to_char(to_date('2017-10-31','yyyy-mm-dd') - (level-1),'yyyy-mm-dd') as dt from dual connect by level <= 31)d
     on d.dt=to_char(column_name,'yyyy-mm-dd') 
     group by d.dt
      order by d.dt