关于全日期的统计

            "select t1.s_date as mydate, decode(t2.iDate, null, 0, t2.iCount) as icount " +
            " from " +
            "(select to_date('{0}','yyyy-mm-dd')+(rownum-1) s_date from all_tables " +
            "where rownum <= " +
            "(select to_date('{1}','yyyy-mm-dd') - to_date('{0}','yyyy-mm-dd')+1 from dual))t1, " +
            "(select to_date(to_char(ffailtime,'YYYY-MM-DD'), 'YYYY-MM-DD') as iDate, count(*) as iCount from tabservfail " +
            "where ffailtime between to_date('{0}', 'YYYY-MM-DD') and to_date('{1}', 'YYYY-MM-DD') " +
            "group by to_char(ffailtime,'YYYY-MM-DD'))t2 " +
            "where t1.s_date = t2.iDate(+) ";