в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T09:59:42Z

1 версия

Новая страница

=="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>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL/PL SQL/Between and - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия