Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle text and CLOBs

Re: Oracle text and CLOBs

From: Joe Raube <joe_at_fullmoondba.com>
Date: Mon, 17 Dec 2001 13:22:34 -0800
Message-ID: <F001.003DE6CC.20011217131636@fatcity.com>

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
>wiwaniec_at_novalistech.com
>http://www.novalistech.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Witold Iwaniec
> INET: wiwaniec_at_novalistech.com
>
>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: ListGuru_at_fatcity.com (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: joe_at_fullmoondba.com

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: ListGuru_at_fatcity.com (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).
Received on Mon Dec 17 2001 - 15:22:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US