Oracle Error ORA-01560: LIKE pattern contains partial or illegal character

Oracle Error Message

ORA-01560: LIKE pattern contains partial or illegal character

Reason for the Error

like pattern is not formed correctly

Solution

make sure like pattern is specified correctly