Home » Server Options » Text & interMedia » Oracle Text index catsearch order by close match (Oracle 11g )
Oracle Text index catsearch order by close match [message #616116] Thu, 12 June 2014 07:01 Go to previous message
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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
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:
  


Current Time: Thu Jan 23 10:57:43 CST 2020