Oracle PL/SQL/PL SQL/Operator

Not equal operator

 
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>