(1=1 or 1=0) and 0=1 : OR « Select Query « Oracle PL / SQL






(1=1 or 1=0) and 0=1

   

SQL>
SQL> select 'is true  ' as condition
  2  from   dual
  3  where  (1=1 or 1=0) and 0=1;

no rows selected

   
    
    
  








Related examples in the same category

1.Query specific columns with where clause and 'or' operator
2.OR operator
3.OR operator : combine date compare and number compare
4.Query specific columns with where clause, or operator and order by
5.1=1 or (1=0 and 0=1) (put and into parentheses)
6.1=1 or 1=0 and 0=1 (no parentheses)
7.Use or to connect two boolean expression
8.OR operator combines two comparisons into one