Mega Code Archive

 

Categories / Oracle PLSQL / Select Query

 

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>