Oracle Text Search Issue
From: DeB <debashish.majumdar_at_gmail.com>
Date: Mon, 20 Jul 2009 02:52:27 -0700 (PDT)
Message-ID: <28db5b5e-c87b-4668-990c-5fdbe5f1b1c8_at_h11g2000yqb.googlegroups.com>
Hi All,
Date: Mon, 20 Jul 2009 02:52:27 -0700 (PDT)
Message-ID: <28db5b5e-c87b-4668-990c-5fdbe5f1b1c8_at_h11g2000yqb.googlegroups.com>
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 DeBReceived on Mon Jul 20 2009 - 04:52:27 CDT