Skip to Main Content

Database Software

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!

Fuzzy String matchin Oracle Text

KoolstensJul 11 2014 — edited Nov 27 2014

I have a table called auction :

Create table auction(item_id varchar2(10), title varchar2(100));

Create table auction(item_id varchar2(10), title varchar2(100));

I create created a context index on the title column :

create index AUCTION_TITLE_CONTEX on auction(title) indextype is ctxsys.context parameters ('DATASTORE CTXSYS.DEFAULT_DATASTORE');

create index AUCTION_TITLE_CONTEX on auction(title) indextype is ctxsys.context parameters ('DATASTORE CTXSYS.DEFAULT_DATASTORE');

I insert inserted some data in the table :

 

insert into auction values ('1','wilkin');

select score(1), title FROM AUCTION where contains(title,'fuzzy('wilkin',,,weight)',1) >0 order by score(1) desc;

insert into auction values ('1','wilkin');  select score(1), title FROM AUCTION where contains(title,'fuzzy('wilkin',,,weight)',1) >0 order by score(1) desc;

the The result for the score(1) is 48.

You can see that 'wilkin' is an exact match to 'wilkin' .

Why is the score is not 100?

 

what What can i I do in my index for all exact match matches to give 100 as score?

 

Thank you?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2014
Added on Jul 11 2014
45 comments
18,556 views