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