Murad Kasp

SELECT dish_name FROM dish
  JOIN dish_ingredients …
  JOIN ingredients …
  GROUP BY dish_name
  HAVING ( LISTAGG( UPPER( ingredient_description ), ',' ) 
           WITHIN GROUP ( ORDER BY ingredient_description )) = 'МУКА,САХАР,ЯЙЦО'

у вас список слов должен быть обязательно в алфавитном порядке

SELECT UPPER( LISTAGG( Name, ',' )) FROM
( SELECT 'мука' AS Name FROM dual
UNION
SELECT 'яйцо' FROM dual
UNION
SELECT 'сахар' FROM dual
ORDER BY 1 )