Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

LIKE operator returns boolean value

SQL> SQL> DECLARE   2     lv_test_bln BOOLEAN;   3  BEGIN   4     lv_test_bln := UPPER('true') LIKE 'TRE%';   5     IF lv_test_bln THEN   6        DBMS_OUTPUT.PUT_LINE('Result: TRUE');   7     ELSE   8        DBMS_OUTPUT.PUT_LINE('Result: FALSE');   9     END IF;  10  END;  11  / Result: FALSE PL/SQL procedure successfully completed. SQL>