Search notes:

Oracle SQL MODEL clause example: Date generator

Generate a series of 100 consecutive dates, starting with today:
select
   dt
from (
   select
      trunc(sysdate) dt
   from
      dual
)
model 
  dimension by (0 d)
  measures     (dt )
  rules iterate(100)
  (
    dt[ iteration_number+1 ] = dt[ iteration_number ]+1
  );

See also

Oracle SQL: Generate (an arbitrary amount of) rows/data
The model clause.

Index