oracle 获取当天所有小时，当月所有天数，当年所有月份

--当天所有小时数
select case when rownum-1 < 10 then concat(to_char(sysdate, 'yyyy-mm-dd '), '0'||to_char(rownum-1)) 
       else concat(to_char(sysdate, 'yyyy-mm-dd '),rownum-1) end  as t_time from dual connect by rownum <= 24;
--当月所有天数
select case when rownum < 10 then concat(to_char(sysdate, 'yyyy-mm-'), '0'||rownum)
       else concat(to_char(sysdate, 'yyyy-mm-'),rownum) end as t_time  from dual connect by rownum <= to_char(last_day(sysdate),'dd');
--当年所有月份数
select to_char(add_months(sysdate,-(select to_char(trunc(sysdate),'mm')from dual )+level ),'yyyy-mm') as t_date from dual connect by level<=12