Oracle Text (MOSC)

MOSC Banner

How to include reserved characters in search criteria

edited Aug 14, 2009 3:27AM in Oracle Text (MOSC) 5 commentsAnswered ✓
 We use a text index on a table called product_text.  We're having a problem searching the index when the search value includes a reserved word.  We tried using escape characters, but they don't seem to work.  For example:

Select * from product_text where contains (text_block,'$75') > 0

returns the same rows as

Select * from product_text where contains (text_block,'\$75') > 0

which, returns the same rows as

Select * from product_text where contains (text_block,'{$75}') > 0

How do we search for a string that includes $, which is a reserved character? 

Any assistance is greatly appreciated.

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