Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE schedule_hdr (schedule_id, schedule_name) AS
SELECT 1, 'Schedule 1' FROM DUAL UNION ALL
SELECT 2, 'Schedule 2' FROM DUAL;
2 rows affected

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'
WITH random_times ( datetime, lvl ) AS (
  SELECT TRUNC(sysdate)
         + NUMTODSINTERVAL( FLOOR(DBMS_RANDOM.VALUE(0,19*60)), 'MINUTE' ),
         1
  FROM   DUAL
UNION ALL
  SELECT datetime + NUMTODSINTERVAL(FLOOR(DBMS_RANDOM.VALUE(6,11)), 'MINUTE'),
         lvl + 1
  FROM   random_times
  WHERE  lvl < 5
)
SELECT sh.schedule_id,
       sh.schedule_name,
       rt.datetime
FROM   schedule_hdr sh
       CROSS JOIN random_times rt
ORDER BY schedule_id, datetime;


SCHEDULE_ID
SCHEDULE_NAME
DATETIME


1
Schedule 1
2020-07-11 13:43:00

1
Schedule 1
2020-07-11 13:49:00

1
Schedule 1
2020-07-11 13:56:00

1
Schedule 1
2020-07-11 14:03:00

1
Schedule 1
2020-07-11 14:10:00

2
Schedule 2
2020-07-11 13:43:00

2
Schedule 2
2020-07-11 13:49:00

2
Schedule 2
2020-07-11 13:56:00

2
Schedule 2
2020-07-11 14:03:00

2
Schedule 2
2020-07-11 14:10:00

SCHEDULE_ID	SCHEDULE_NAME	DATETIME
1	Schedule 1	2020-07-11 13:43:00
1	Schedule 1	2020-07-11 13:49:00
1	Schedule 1	2020-07-11 13:56:00
1	Schedule 1	2020-07-11 14:03:00
1	Schedule 1	2020-07-11 14:10:00
2	Schedule 2	2020-07-11 13:43:00
2	Schedule 2	2020-07-11 13:49:00
2	Schedule 2	2020-07-11 13:56:00
2	Schedule 2	2020-07-11 14:03:00
2	Schedule 2	2020-07-11 14:10:00