select to_char(sysdate -(rownum-1) / 24,'hh24')||':00' totalDate from dual connect by rownum <=(select to_char(sysdate,'hh24')+1 from dual) order by totalDate desc
select to_char(sysdate -(rownum-1) / 24,'hh24')||':00' totalDate from dual connect by rownum <=(select to_char(sysdate,'hh24')+1 from dual) order by totalDate desc