> On Jun 9, 2015, at 2:53 PM, Jean-Christophe Deschamps <jcd at antichoc.net>
> wrote:
>
> Most probably! I can imagine that you don't encounter such style in common
> business-like environments.
Just for ?corporate' fun: analytic recursive common table expression - oh, my?
with
Clock( start_at, end_at, interval, tick )
as
(
select date '2015-01-01' as start_at,
timestamp '2015-01-01 23:59:59' as end_at,
interval '15' minute as interval,
date '2015-01-01' as tick
from dual
union all
select start_at,
end_at,
interval,
tick + interval as tick
from Clock
where tick + interval between start_at and end_at
)
select Clock.tick,
lead( Clock.tick ) over( order by Clock.tick ) as next_tick
from Clock
order by Clock.tick;
