Getting issues with using Like with escape to find '%:%'
I am getting error when I use the following query
select * from table_1 where sql_text like '%!:%' escape '!';
ORA-01424: missing or illegal character following the escape character
There is no issue with the following:
select * from table_1 where sql_text like '%!_%' escape '!';
Can someone explain what is the issues here? I want to find all rows which has : or :" in the sql_text column.
Any suggestion will be highly appreciated.
Nirmal