Re: Oracle Text Search Issue

From: Tim Arnold <timkarnold_at_comcast.net>
Date: Mon, 20 Jul 2009 08:04:19 -0400
Message-ID: <4A645D43.6010302_at_comcast.net>

DeB wrote:
> Hi All,
> I've a table and created a Full Text index on the same as follows:
>
> CREATE TABLE FT_TEST
> (
> COL1 NUMBER(3),
> COL2 VARCHAR2(100 BYTE)
> );
>
> CREATE INDEX IDX_FT_COL2 ON FT_TEST(COL2) INDEXTYPE IS CTXSYS.CONTEXT;
>
> INSERT INTO FT_TEST VALUES(1, 'nt=a;puc=s');
> INSERT INTO FT_TEST VALUES(2, 'nt=a;puc=t');
> INSERT INTO FT_TEST VALUES(3, 'nt=a;puc=a');
>
> EXEC CTX_DDL.SYNC_INDEX('IDX_FT_COL2');
>
>
> When I issue a query like -
>
> SELECT * FROM FT_TEST WHERE CONTAINS(COL2, '{puc=s}') > 1
>
> COL1 COL2
>
> 1 nt=a;puc=s
> 2 nt=a;puc=t
> 3 nt=a;puc=a
>
> I was expecting to get only a single record for 'puc=s'. Am I missing
> any operators to achieve this? Please suggest.
>
> --
> Thanks
> DeB

I suspect you need to define '=' as a skipjoin or printjoin Received on Mon Jul 20 2009 - 07:04:19 CDT