Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get exact match when working with Oracle Text?

5108Jun 12 2008 — edited Jun 23 2008
Hi,

I'm running Oracle9i Database R2.

I would like to know how do I get exact match when working with Oracle Text.

DROP TABLE T_TEST_1;

CREATE TABLE T_TEST_1 (text VARCHAR2(30));

INSERT INTO T_TEST_1 VALUES('Management');
INSERT INTO T_TEST_1 VALUES('Busines Management Practice');
INSERT INTO T_TEST_1 VALUES('Human Resource Management');
COMMIT;

DROP INDEX T_TEST_1;

CREATE INDEX T_TEST_1_IDX ON T_TEST_1(text) INDEXTYPE IS CTXSYS.CONTEXT;

SELECT * FROM T_TEST_1 WHERE CONTAINS(text, 'Management')>0;

The above query will return 3 rows. How do I make Oracle Text to return me only the first row - which is exact match because sometimes my users need to look for exact match term.

Please advise.

Regards,
Jap.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2008
Added on Jun 12 2008
18 comments
2,536 views