OraFAQ Forum: Text & interMedia » Oracle Text index catsearch order by close match

Home » Server Options » Text & interMedia » Oracle Text index catsearch order by close match (Oracle 11g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Text index catsearch order by close match [message #616116]

Thu, 12 June 2014 07:01

ramesh.sannapureddy
Messages: 5
Registered: June 2014
Location: Bangalore

Junior Member

I am using oracle text index of type ctxcat, but I am new oracle text. I am able to query the table and getting the right results. But we want the results in below order.
If the search string contains two strings then order of the results should be,
In top position: Results that have the exact match to the input text
Then: results that have both words
And at the end: results that have at least one of the two words.

Report message to a moderator

[Message index]

		Oracle Text index catsearch order by close match By: ramesh.sannapureddy on Thu, 12 June 2014 07:01
		Re: Oracle Text index catsearch order by close match By: Barbara Boehmer on Thu, 12 June 2014 09:25
		Re: Oracle Text index catsearch order by close match By: ramesh.sannapureddy on Sat, 05 July 2014 09:16
		Re: Oracle Text index catsearch order by close match By: Barbara Boehmer on Sat, 05 July 2014 11:42
		Re: Oracle Text index catsearch order by close match By: ramesh.sannapureddy on Mon, 07 July 2014 02:09
		Re: Oracle Text index catsearch order by close match By: Barbara Boehmer on Mon, 07 July 2014 18:21

Previous Topic:	Text Index return min of words specified
Next Topic:	How to use Oracle text (split from hijacked topic "Find Words in a String")

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 19:55:29 CDT 2024