PL/SQL (MOSC)

MOSC Banner

How to search a CLOB for the '*' character ?

edited Oct 13, 2010 5:43AM in PL/SQL (MOSC) 7 commentsAnswered
 I have built a context index on a CLOB field and the CONTAINS function/phrase works great, until I realized that I sometimes want to search for a string of characters made up of 3 asterisks, like this '***', or 'RANDY***'. I see that the asterisk is the wildcard for Context Indexes, but does anyone know of a way to search for any string with embedded asterisks ?

Thanks,

--Randy

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