See docs on Stop Words: http://download-west.oracle.com/otndoc/oracle9i/901_doc/text.901/a90122/ind4.htm#1010184
Using Stopwords and Stoplists A stopword is a word that is not to be indexed. A stopword is usually a low information word such as THIS or that in English. In other words, IS and THIS are stopwords and are not being indexed. -Joe At 12:45 PM 12/17/01 -0800, Witold Iwaniec wrote: >Hi all > >I am experimenting with Oracle Text and CLOBs in Oracle 8.1.7 and >have run into something strange. > >I have a table, LRMI_NOTE, with column NOTE_DATA that is >defined as a CLOB. > >SELECT NOTE_DATA FROM LRMI_DATA; > >NOTE_DATA >============== >this is starting test > >I have built both ctxsys.context and ctxsys.ctxcat indexes. When I >run: > >select * from lrmi_note where contains(note_data, 'test') > 0 >or >select * from lrmi_note where contains(note_data, 'starting') > 0 > >I get back the record. But when I run: > >select * from lrmi_note where contains(note_data, 'is') > 0 >or >select * from lrmi_note where contains(note_data, 'this') > 0 > >I don't get anything back. The same happens when I used the >catsearch() function. > >I updated this column, set to various strings so that "this" and "is" >were in different positions in the string, but couldn't get anything >back using "is" or "this" in my queries. > >Can anyone explain this? > >Thanks > >Witold > >================================== >Witold Iwaniec >Sr Software Developer >NovaLIS Technologies >[EMAIL PROTECTED] >http://www.novalistech.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Witold Iwaniec > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
