The like Sql condition in Oracle Database SQL
like 'Pattern'
where the pattern can contain special pattern-matching characters:
You can include the actual characters % or _ in the pattern by using the ESCAPE clause, which identifies the escape character.
SELECT 'true' FROM dual WHERE '1' LIKE '_' ESCAPE '\';
will return true because 1 is a character.
SELECT 'true' FROM dual WHERE '1' LIKE '\_' ESCAPE '\';
will return nothing because 1 is different from an underscore.