This discussion is archived
2 Replies Latest reply: Nov 20, 2012 11:45 PM by 882532 RSS

Oracle Text, search text with special characters

882532 Newbie
Currently Being Moderated
Hi all,

My DBA: 11.2.03

I have index ctxsys.context on some column.

Now, I would like to find a text such as '891-000-33-01' (without '').

The problem is that, I can find propely row when I write *'891 000 33 01'*,
and no rows result when write normal *'891-000-33-01'*.

How to construct an index, or what I must do to typed text with special characters searched for the text you enter, and did not act like google search (*when you write in google "cat -animal", serach engine returns the results of non-animal cat*)



  • Correct Answers - 10 points
  • Helpful Answers - 5 points