WHERE-Bedingung mit Set-Values

SELECT *
  FROM emp e
 WHERE 1 = 1
   AND (e.deptno, e.job) IN
        (SELECT 20, UPPER('analyst')
           FROM dual)
;