BETWEEN operator checks whether a variable value is between two values of the same datatype. : BETWEEN AND « Select Query « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Select Query
  3. BETWEEN AND

BETWEEN operator checks whether a variable value is between two values of the same datatype.

   
SQL>
SQL>  BEGIN
  2    IF 1 BETWEEN 1 AND 3 THEN
  3     dbms_output.put_line('In the range.');
  4    END IF;
  5   END;
  6   /
In the range.

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.Using the BETWEEN ... AND operator for Number
2.Exclude a range with NOT operator: NOT BETWEEN AND
3.Between for Date data type
4.Using the BETWEEN Operator for integer
5.BETWEEN (SYSDATE-30) AND SYSDATE
6.'Between...And' converts text value to date type value
7.Performing Range Tests with between ... and
8.Performing Range Tests, not between ... and
9.All flower product with price range between 10 and 25