LIKE operator returns boolean value : LIKE « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. LIKE

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>

 

Related examples in the same category