By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test( flight NUMBER(4), "date" DATE, action VARCHAR2(50) );
BEGIN
INSERT INTO test VALUES ('1234', timestamp'2020-02-29 18:00:00', 'Departure');
INSERT INTO test VALUES ('1234', timestamp'2020-02-29 19:00:00', 'Arrival');
INSERT INTO test VALUES ('4321', timestamp'2020-02-20 21:00:00', 'Departure');
INSERT INTO test VALUES ('4321', timestamp'2020-02-20 22:00:00', 'Departure');
INSERT INTO test VALUES ('4321', timestamp'2020-02-21 04:30:00', 'Arrival');
END;
/
1 rows affected
SELECT flight
FROM test
WHERE action in ('Departure','Arrival')
GROUP BY flight, trunc("date")
HAVING COUNT(distinct action)=2
| FLIGHT |
|---|
| 1234 |