Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

Between and operator for number value

SQL> SQL> SQL> DECLARE   2     lv_test_bln BOOLEAN;   3  BEGIN   4     lv_test_bln := 3 BETWEEN 1 and 10;   5     IF lv_test_bln THEN   6        DBMS_OUTPUT.PUT_LINE('Result: TRUE');   7     ELSE   8        DBMS_OUTPUT.PUT_LINE('Result: FALSE');   9     END IF;  10  END;  11  / Result: TRUE PL/SQL procedure successfully completed. SQL> SQL>