'Between...and' operator for number value : Between and « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. Between and

'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>

 

Related examples in the same category