This discussion is archived
1 Reply Latest reply: Sep 10, 2012 1:09 AM by Herald ten Dam RSS

oracle  'INDEX_STEMS','NONE' how to use

961017 Newbie
Currently Being Moderated
oracle 'INDEX_STEMS','NONE' how to use
  • 1. Re: oracle  'INDEX_STEMS','NONE' how to use
    Herald ten Dam Expert
    Currently Being Moderated

    welcome. You can read the manual for this kind of questions ( but the simplest form is the next one:
      ctx_ddl.create_preference('mylex', 'BASIC_LEXER');
      ctx_ddl.set_attribute('mylex', 'index_stems', 'NONE');
    Then you can use this preference in the creation of your index:
      create index myindex on mytable ( docs ) 
      indextype is ctxsys.context 
      parameters ( 'LEXER mylex' ); 
    Herald ten Dam


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