SQL*Plus (MOSC)

MOSC Banner

Getting issues with using Like with escape to find '%:%'

edited May 16, 2014 12:00PM in SQL*Plus (MOSC) 3 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center