Processing of special characters like query underline in Oracle

You can include the actual character "%" or "_" in the pattern using the exception clause, which determines the escape character. If the escape character appears in the pattern in the character "%" or "_", Oracle will interpret the pattern on this character instead of as a special pattern match character.

Search for patterns A_b employees in their name:

SELECT last_name from     employees    WHERElike'%a\_b%'ESCAPE' \';            



The disclaimer backslash (\) is recognized as an escape character. In this mode, the escape character is an underscore (_). This causes the underscore to be interpreted by Oracle, not as a special pattern-matching character.

Processing of special characters like query underline in Oracle