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!

help with fulltext-search using a thesaurus

400595Oct 21 2003
Hi,

I'm very new at using oracle text/thesaurus, so I really hope you can help me :)

I would perform a fulltext-search using a thesaurus. This means any word should be checked for synonyms and narrow terms. How can I do this?

I know the functions ctx_thes.syn and ctx_thes.nt but I don't know how to do some "complex" interaction with them. It's no problem to get e.g. the synonyms OR the nt's for a word, but when I try to combine this two functions I don't know how to do this. Do I have to split the result-string of one function? Or is there another way?

With my (yet) limited understanding of this I would do this:

1) Look for a synonym of the searchterm
2) Look for nt's both of the searchterm and each synonym

Is this the right way?

And how can I look for the nt's of the synonyms? I ask because the result is a {abc}|{def}-string. Do I have to split this into "abc" and "def" and pass this two values to the ctx_thes.nt-function?

Thanks for any help :)

Jens
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2003
Added on Oct 21 2003
0 comments
204 views