Select Query Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Select Query
  4. 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>