Oracle 18c

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

CREATE TABLE T_TMP_SLOT as Select 1 as ID, TO_DATE('11/10/2021 09:00:00', 'DD/MM/YYYY HH24:MI:SS') as SLOT_BEG, TO_DATE('11/10/2021 09:15:00', 'DD/MM/YYYY HH24:MI:SS') as SLOT_END
FROM DUAL
UNION ALL
Select 2 as ID, TO_DATE('11/10/2021 09:15:00', 'DD/MM/YYYY HH24:MI:SS') as SLOT_BEG, TO_DATE('11/10/2021 09:30:00', 'DD/MM/YYYY HH24:MI:SS') as SLOT_END
FROM DUAL
UNION ALL
Select 3 as ID, TO_DATE('11/10/2021 09:30:00', 'DD/MM/YYYY HH24:MI:SS') as SLOT_BEG, TO_DATE('11/10/2021 09:45:00', 'DD/MM/YYYY HH24:MI:SS') as SLOT_END
FROM DUAL
UNION ALL
Select 4 as ID, TO_DATE('11/10/2021 09:45:00', 'DD/MM/YYYY HH24:MI:SS') as SLOT_BEG, TO_DATE('11/10/2021 10:00:00', 'DD/MM/YYYY HH24:MI:SS') as SLOT_END
FROM DUAL
;

4 rows affected

CREATE TABLE T_TMP_MEET as Select 1 as ID, TO_DATE('11/10/2021 09:00:00', 'DD/MM/YYYY HH24:MI:SS') as MEET_BEG, TO_DATE('11/10/2021 09:15:00', 'DD/MM/YYYY HH24:MI:SS') as MEET_END
FROM DUAL
UNION ALL
Select 2 as ID, TO_DATE('11/10/2021 09:32:24', 'DD/MM/YYYY HH24:MI:SS') as MEET_BEG, TO_DATE('11/10/2021 09:46:00', 'DD/MM/YYYY HH24:MI:SS') as MEET_END
FROM DUAL
;
2 rows affected

select ID, TO_CHAR(SLOT_BEG,'DD/MM/YYYY HH24:MI:SS'), TO_CHAR(SLOT_END, 'DD/MM/YYYY HH24:MI:SS') from t_tmp_slot;


ID
TO_CHAR(SLOT_BEG,'DD/MM/YYYYHH24:MI:SS')
TO_CHAR(SLOT_END,'DD/MM/YYYYHH24:MI:SS')


1
11/10/2021 09:00:00
11/10/2021 09:15:00

2
11/10/2021 09:15:00
11/10/2021 09:30:00

3
11/10/2021 09:30:00
11/10/2021 09:45:00

4
11/10/2021 09:45:00
11/10/2021 10:00:00


select ID, TO_CHAR(MEET_BEG,'DD/MM/YYYY HH24:MI:SS'), TO_CHAR(MEET_END, 'DD/MM/YYYY HH24:MI:SS') from t_tmp_meet;


ID
TO_CHAR(MEET_BEG,'DD/MM/YYYYHH24:MI:SS')
TO_CHAR(MEET_END,'DD/MM/YYYYHH24:MI:SS')


1
11/10/2021 09:00:00
11/10/2021 09:15:00

2
11/10/2021 09:32:24
11/10/2021 09:46:00


Select 2 as ID, TO_DATE('11/10/2021 09:15:00', 'DD/MM/YYYY HH24:MI:SS') as SLOT_BEG, TO_DATE('11/10/2021 09:30:00', 'DD/MM/YYYY HH24:MI:SS') as SLOT_END
FROM DUAL
;


ID
SLOT_BEG
SLOT_END


2
11-OCT-21
11-OCT-21


/* I think I need inverse of something like this - NOT WORKS PROPERLY */
SELECT s.*, m.*
  FROM t_tmp_slot s, t_tmp_meet m
 WHERE slot_beg BETWEEN meet_beg AND (meet_end - INTERVAL '1' SECOND) OR slot_end BETWEEN (meet_beg + INTERVAL '1' SECOND) AND meet_end


ID
SLOT_BEG
SLOT_END
ID
MEET_BEG
MEET_END


1
11-OCT-21
11-OCT-21
1
11-OCT-21
11-OCT-21

3
11-OCT-21
11-OCT-21
2
11-OCT-21
11-OCT-21

4
11-OCT-21
11-OCT-21
2
11-OCT-21
11-OCT-21

ID	TO_CHAR(SLOT_BEG,'DD/MM/YYYYHH24:MI:SS')	TO_CHAR(SLOT_END,'DD/MM/YYYYHH24:MI:SS')
1	11/10/2021 09:00:00	11/10/2021 09:15:00
2	11/10/2021 09:15:00	11/10/2021 09:30:00
3	11/10/2021 09:30:00	11/10/2021 09:45:00
4	11/10/2021 09:45:00	11/10/2021 10:00:00

ID	TO_CHAR(MEET_BEG,'DD/MM/YYYYHH24:MI:SS')	TO_CHAR(MEET_END,'DD/MM/YYYYHH24:MI:SS')
1	11/10/2021 09:00:00	11/10/2021 09:15:00
2	11/10/2021 09:32:24	11/10/2021 09:46:00

ID	SLOT_BEG	SLOT_END	ID	MEET_BEG	MEET_END
1	11-OCT-21	11-OCT-21	1	11-OCT-21	11-OCT-21
3	11-OCT-21	11-OCT-21	2	11-OCT-21	11-OCT-21
4	11-OCT-21	11-OCT-21	2	11-OCT-21	11-OCT-21