RE: "google search" using Oracle Text

From: Ivan Chow <ichow2_at_hotmail.com>
Date: Mon, 19 Apr 2004 09:09:59 -0400
Message-ID: <BAY12-F512wRamVysde000568d8@hotmail.com>

Niall, ABOUT will not work well. It does searches using Theme.

SQL>select * from mytab;
MYID MYTEXT

---------- --------------------
         1 DIESEL ENGINE
         2 AUTO ENGINE PARTS
         4 ENG FOR SALE
         5 GOOGLE SEARCH ENGINE
         6 VOLVO ENGINE

5 rows selected.

SQL>select mytext, score(1) from mytab where contains (mytext, 'about (car)',1)>1;

MYTEXT                          SCORE(1)
--------------------                  ----------
AUTO ENGINE PARTS                100

1 row selected.

Even though the query above does not contain any of the tokens "AUTO", "ENGINE" or "PARTS", a record is still returned.

SQL> select mytext,score(1) from mytab where contains (mytext, 'about(GOOGLE SEARCH ENGINE)',1)>1;

MYTEXT                          SCORE(1)
--------------------                     ----------
GOOGLE SEARCH ENGINE            84

1 row selected.

If I were to search on "GOOGLE SEARCH ENGINE", it returns only one record. I want it to return all of the following records (any records that contains "GOOGLE SEARCH ENGINE", "GOOGLE","SEARCH", "ENGINE"):

         1 DIESEL ENGINE
         2 AUTO ENGINE PARTS
         5 GOOGLE SEARCH ENGINE
         6 VOLVO ENGINE

Thanks.

Ivan

>From: "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk>
>Reply-To: oracle-l_at_freelists.org
>To: <oracle-l_at_freelists.org>
>Subject: RE: "google search" using Oracle Text
>Date: Mon, 19 Apr 2004 13:11:30 +0100
>
>Try looking into the about operator but you might beware of how many hits
>i=
>t might return
>
>NIALL 19-APR-2004 13:08_at_nl9204>;
> 1* select * from test_text
>NIALL 19-APR-2004 13:08_at_nl9204>/
>
> ID TEXT_DATA
>=
> =20
>---------- --------------------------------------------------
>=
> =20
> 1 RAC Concepts and Administration
>=
> =20
> 2 RAC beginners guide
>=
> =20
> 3 Ultra Search Docs
>=
> =20
> 4 Ultra Search Concepts
>=
> =20
>
>4 rows selected.
>
>NIALL 19-APR-2004 13:08_at_nl9204> select id,text_data
> 2 from test_text
> 3* where contains(text_data,'about(Rac Concepts)') > 0
>
> ID TEXT_DATA
>=
> =20
>---------- --------------------------------------------------
>=
> =20
> 4 Ultra Search Concepts
>=
> =20
> 2 RAC beginners guide
>=
> =20
> 1 RAC Concepts and Administration
>=
> =20
>
>3 rows selected.
>
>NIALL 19-APR-2004 13:09_at_nl9204>spoo off
>
>
>**********************************************************************
>This email contains information intended for
>the addressee only. It may be confidential
>and may be the subject of legal and/or
>professional privilege. Any dissemination,
>distribution, copyright or use of this
>communication without prior permission of
>the sender is strictly prohibited.
>**********************************************************************
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------

FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.com/go/onm00200415ave/direct/01/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Apr 19 2004 - 08:06:40 CDT