Re: Full text search

From: William Beilstein <BeilstWH_at_OBG.com>
Date: Wed, 13 Sep 2000 08:57:25 -0400
Message-Id: <10618.116821@fatcity.com>

You want the Oracle module ConText, with is designed for what you want.

>>> "Witold Iwaniec" <wiwaniec_at_novalistech.com> 09/13/00 08:45AM >>>
Hi all

In our product we have to support long text fields so we use=20 columns defined as VARCHAR2 (2000)
It seems to do the job but we are looking for a way to enable full=20 text search.=20

Running statements like:
'SELECT text_value FROM client_note WHERE text_value LIKE=20 '%SPEED%'=20 would be very slow and always require full table scan. Is there a=20 better way of doing it, especially in the Oracle 8i world?

Thanks

Witold

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Witold Iwaniec
Senior Software Developer
NovaLIS Technologies
wiwaniec_at_novalistech.com =20
http://www.novalistech.com=20
--=20
Author: Witold Iwaniec
  INET: wiwaniec_at_novalistech.com=20

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 Wed Sep 13 2000 - 07:57:25 CDT