|
SQL>
SQL> set serveroutput on
SQL>
SQL>
SQL> DECLARE
2 lv_test_bln BOOLEAN;
3 BEGIN
4 lv_test_bln := UPPER('AAA') IN ('TRE','B','N');
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: FALSE
PL/SQL procedure successfully completed.
|