3,491
社区成员
发帖
与我相关
我的任务
分享
with tab1 as (
select trunc(sysdate, 'hh24') + level / 24 dt from dual connect by level <= 6
)
select t1.dt + (level - 1) / 24 / 60 * 15 from tab1 t1
connect by level <= 4
and prior t1.dt = t1.dt
and prior sys_guid() is not null