一个ORACLE间隔时间的查询语句

select distinct(d.dt), sum(d.num) from (  select dt, count(*) as num,i.row_id,i.created_date from testtable  i,  (select to_date('2011/12/4 18:54:30','yyyy/mm/dd HH24:mi:ss') + (level-1)/86400*5 dt from dual connect by level <= 2000) d     where   i.created_date>=dt and i.created_date < d.dt+(5/86400)     group by d.dt,i.row_id,i.created_date  order by dt) d group by d.dt