Oracle PL/SQL/PL SQL/Operator

Not equal operator

   <source lang="sql">

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>

</source>