select * from (select '1' a1,'2' a2 from dual
union
select '3','4' from dual)
where (a1,a2) in (select '1','2' from dual union
select '3','4' from dual)
union
select '3','4' from dual)
where (a1,a2) in (select '1','2' from dual union
select '3','4' from dual)