Oracle 21c

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 table_name (CUST_ID, ORDER_ID) AS
SELECT 12455, 4070 FROM DUAL UNION ALL
SELECT 12454, 4070 FROM DUAL UNION ALL
SELECT 12454, 4077 FROM DUAL UNION ALL
SELECT 12455, 4077 FROM DUAL UNION ALL
SELECT 12454, 2659 FROM DUAL UNION ALL
SELECT 12455, 1928 FROM DUAL UNION ALL
SELECT 12454, 2012 FROM DUAL UNION ALL
SELECT 12453, 1354 FROM DUAL;
8 rows affected

CREATE TYPE number_list IS TABLE OF NUMBER;
SELECT order_id
FROM   table_name
WHERE  cust_id MEMBER OF number_list(12455, 12454)
GROUP BY order_id
HAVING COUNT(DISTINCT cust_id) = CARDINALITY(number_list(12455, 12454))


ORDER_ID


4070

4077


SELECT order_id
FROM   table_name
WHERE  cust_id MEMBER OF number_list(12455, 12454, 12453)
GROUP BY order_id
HAVING COUNT(DISTINCT cust_id) = CARDINALITY(number_list(12455, 12454, 12453))