Script:

select 'is true ' as condition
from dual
where 1=1 or 1=0 and 0=1;
 

Oracle:


PostgreSQL :

Select 'There is No Dual '

Another condition:

SELECT 1=2, 1=1