The problem comes from the fact that, in an Oracle database ... returns NULL is always ignored. For example, neither one of these queries return any rows: select ‘true’ from dual where ...