Oracle PL/SQL/PL SQL/LIKE

LIKE operator in PL/SQL

   <source lang="sql">

SQL> DECLARE

 2     lv_training_code_txt VARCHAR2(10) := "T_Code";
 3     lv_non_training_code_txt VARCHAR2(10) := "TUSC";
 4     PROCEDURE training_class_check (p_class_check VARCHAR) IS
 5     BEGIN
 6        IF p_class_check LIKE "T_%" THEN
 7           DBMS_OUTPUT.PUT_LINE(p_class_check ||" is a Training Class");
 8        ELSE
 9           DBMS_OUTPUT.PUT_LINE(p_class_check ||" is a Non-Training Class");
10        END IF;
11     END training_class_check;
12
13  BEGIN
14     training_class_check(lv_training_code_txt);
15     training_class_check(lv_non_training_code_txt);
16  END;
17  /

T_Code is a Training Class TUSC is a Training Class PL/SQL procedure successfully completed. SQL> SQL> --

</source>
   
  

LIKE operator returns boolean value

   <source lang="sql">

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>

</source>