Oracle PL/SQL/PL SQL/Between and

Материал из SQL эксперт
Перейти к: навигация, поиск

"Between...and" operator converts text to date type

   <source lang="sql">

SQL> SQL> SQL> DECLARE

 2     lv_test_date VARCHAR2(10) := "01-FEB-99";
 3  BEGIN
 4     IF  lv_test_date BETWEEN "31-JAN-99" AND "10-FEB-99" THEN
 5        DBMS_OUTPUT.PUT_LINE("TRUE");
 6     ELSE
 7        DBMS_OUTPUT.PUT_LINE("FALSE");
 8     END IF;
 9  END;
10  /

FALSE PL/SQL procedure successfully completed. SQL>

</source>
   
  


"Between...and" operator for Date type

   <source lang="sql">

SQL> SQL> SQL> DECLARE

 2     lv_test_date DATE := "01-FEB-99";
 3  BEGIN
 4     IF  lv_test_date BETWEEN "31-JAN-99" AND "10-FEB-99" THEN
 5        DBMS_OUTPUT.PUT_LINE("TRUE");
 6     ELSE
 7        DBMS_OUTPUT.PUT_LINE("FALSE");
 8     END IF;
 9  END;
10  /

TRUE PL/SQL procedure successfully completed. SQL>

</source>
   
  


"Between...and" operator for number value

   <source lang="sql">

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>

</source>
   
  


"Between...and" operator for text value

   <source lang="sql">

SQL> SQL> SQL> BEGIN

 2    IF "C" BETWEEN "A" AND "D" THEN
 3        DBMS_OUTPUT.PUT_LINE("TRUE");
 4      ELSE
 5         DBMS_OUTPUT.PUT_LINE("FALSE");
 6      END IF;
 7  END;
 8  /

TRUE PL/SQL procedure successfully completed. SQL>

</source>