Oracle 18c

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

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE locations AS
SELECT level AS location_id,
       'Door ' || level AS location_name,
       CASE FLOOR(dbms_random.value(1,4)) 
       WHEN 1 THEN 'A' 
       WHEN 2 THEN 'T' 
       WHEN 3 THEN 'G' 
       END AS location_type
FROM   dual
CONNECT BY level <= 25; 
25 rows affected

WITH input (start_time) AS (
  SELECT TRUNC(SYSDATE) + INTERVAL '23:30' HOUR TO MINUTE FROM DUAL
)
SELECT start_time + (LEVEL-1) * INTERVAL '10' MINUTE
         AS t_from,
       start_time + (LEVEL-1) * INTERVAL '10' MINUTE + INTERVAL '5' MINUTE
         AS t_to
FROM   input
CONNECT BY (LEVEL-1) * INTERVAL '10' MINUTE < INTERVAL '1' DAY
AND    LEVEL <= (SELECT COUNT(*) FROM locations)
AND    start_time + (LEVEL-1) * INTERVAL '10' MINUTE < TRUNC(start_time) + INTERVAL '1' DAY;


T_FROM
T_TO


2021-08-16 23:30:00
2021-08-16 23:35:00

2021-08-16 23:40:00
2021-08-16 23:45:00

2021-08-16 23:50:00
2021-08-16 23:55:00

T_FROM	T_TO
2021-08-16 23:30:00	2021-08-16 23:35:00
2021-08-16 23:40:00	2021-08-16 23:45:00
2021-08-16 23:50:00	2021-08-16 23:55:00