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






  1. Oracle PL / SQL
  2. Select Query
  3. OR

1=1 or 1=0 and 0=1 (no parentheses)

   

SQL>
SQL>

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

CONDITION
---------
is true

SQL>
SQL>
SQL>








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
6.1=1 or (1=0 and 0=1) (put and into parentheses)
7.Use or to connect two boolean expression
8.OR operator combines two comparisons into one