WITH dates AS (select COLUMN_VALUE d from table(sys.odcinumberlist(10, 20, 30, 40, 50, 60, 70, 80, 90)))
, shifts AS (select COLUMN_VALUE shift from table(sys.odcinumberlist(0, 1, 2, 3, 4, 5, 6, 7, 9)))
Select dt.d + sht.shift as d
From dates dt, shifts sht
Order by 1;

WITH dates AS (select COLUMN_VALUE d from table(sys.odcinumberlist(10, 20, 30, 40, 50, 60, 70, 80, 90)))
, r_dates(dstart, d, lv) as (
  Select d as dstart, d , 1 as lv
  From dates 
  Union All 
  Select dstart, dstart + lv, lv + 1
  From r_dates 
  Where 
  1 = 1 
  and lv < 10
)
SEARCH DEPTH FIRST BY D SET rn
Select * from r_dates
;

WITH dates AS (select COLUMN_VALUE d from table(sys.odcinumberlist(10, 20, 30, 40, 50, 60, 70, 80, 90)))
select d as dstart, d+level-1 as dd , level as lv
from dates
connect by d = prior d  and level <= 10
and prior dbms_random.value is not null