Does the Oracle query check both values in a row? Which would be this:

SELECT

ID,

Name

FROM

EMP_TBL

WHERE

(ID = 1 AND Name = 'foo1')

OR

(ID = 2 AND Name = 'foo2')