OR operator combines two comparisons into one : OR « Select Query « Oracle PL / SQL






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

OR operator combines two comparisons into one

   

SQL>
SQL>  BEGIN
  2    IF 1 = 1 OR 1 = 2 THEN
  3    dbms_output.put_line('True.');
  4    END IF;
  5   END;
  6   /
True.

PL/SQL procedure successfully completed.

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.1=1 or 1=0 and 0=1 (no parentheses)
8.Use or to connect two boolean expression