9 Replies Latest reply on Oct 9, 2012 11:31 AM by bobonacus

    using CONTAINS to find exact phrase not working

      I am trying to use a context index to serch some text for the exact phrase INSERT INTO
      create table temp_source as select name, type, line, upper(text) as text from user_source;
      create index usr_src_text on temp_source (text) indextype is ctxsys.context;
      select * from temp_source where contains(text, 'INSERT INTO') > 0;
      documentation I've read on several sites all says any of these should work as they all do the same

      'INSERT INTO' '"INSERT INTO"' 'INSERT & INTO' 'INSERT AND INTO' but they all return results that just have INSERT in