The problem comes from the fact that, in an Oracle database ... select ‘true’ from dual where null is null; When you use IN, you’re telling SQL to take a value and compare it against ...