Not equal operator : Operator « PL SQL « Oracle PL / SQL





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>

 










Related examples in the same category