2 Replies Latest reply: Nov 21, 2012 1:45 AM by 882532 RSS

    Oracle Text, search text with special characters

      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*)