DECLARE
PROCEDURE pat_match (
test_string VARCHAR2,
pattern VARCHAR2
) IS
BEGIN
IF test_string LIKE pattern THEN
DBMS_OUTPUT.PUT_LINE ('TRUE');
ELSE
DBMS_OUTPUT.PUT_LINE ('FALSE');
END IF;
END;
BEGIN
pat_match('Blweate', 'B%a_e');
pat_match('Blweate', 'B%A_E');
END;
/
PL/SQL Code:
Sample Output:
need an explanation for this answer? contact us directly to get an explanation for this answer