SQL>
SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL> DECLARE
2 lv_test_num NUMBER(3);
3 lv_test_txt VARCHAR2(5);
4 lv_complete_bln BOOLEAN;
5 BEGIN
6 IF lv_test_num != 10 THEN
7 DBMS_OUTPUT.PUT_LINE("Number Test: TRUE");
8 ELSE
9 DBMS_OUTPUT.PUT_LINE("Number Test: FALSE");
10 END IF;
11 IF lv_test_txt != "TEMP" THEN
12 DBMS_OUTPUT.PUT_LINE("Character Test: TRUE");
13 ELSE
14 DBMS_OUTPUT.PUT_LINE("Character Test: FALSE");
15 END IF;
16 IF NOT lv_complete_bln THEN
17 DBMS_OUTPUT.PUT_LINE("Boolean Test: TRUE");
18 ELSE
19 DBMS_OUTPUT.PUT_LINE("Boolean Test: FALSE");
20 END IF;
21 END;
22 /
Number Test: FALSE
Character Test: FALSE
Boolean Test: FALSE
PL/SQL procedure successfully completed.
SQL>
SQL>