Oracle Error ORA-01424: missing or illegal character following the escape character

Oracle Error Message

ORA-01424: missing or illegal character following the escape character

Reason for the Error

The character following the escape character in LIKE pattern is missing or not one of the escape character, ‘%’, or ‘_’.

Solution

Remove the escape character or specify the missing character.