利用oracle 递归查询构造特定表

生成每15分钟一个点的结果集

select x.time_point,level from(
select to_date('2008-05-01 00:00', 'yyyy-mm-dd hh24:mi') + level / (24 * 4) -
       1 / (24 * 4) as time_point
  from dual
connect by level <= (to_date('20080502', 'yyyymmdd')  -   to_date('20080501', 'yyyymmdd') + 1)*24*4) x;