Home » Server Options » Text & interMedia » ORACLE Text Search -DEFINESCORE with COMPLETION (Oracle -10g)
ORACLE Text Search -DEFINESCORE with COMPLETION [message #563802] Fri, 17 August 2012 03:46 Go to next message
Messages: 74
Registered: May 2007
Location: Chester


I have created MULTI_COLUMN_DATASTORE indexes on certain columns of tables.

Now i have different combinations to search with different scoring method(RELEVANCE,COMPLETION)

My query text looks like...

  <textquery grammar="CONTEXT" lang="english">
        DEFINESCORE (Labradors are big dog, RELEVANCE)   * 10
       ,DEFINESCORE (dog, COMPLETION) WITHIN zonesection * 5
  <score datatype="integer" algorithm="COUNT"/>.

With this i am trying to get all related results and most matching one on top.

Now my question is..
For WITHIN section, how can i define zonesection for table or columns?


Ganesh Jadhav

[Updated on: Fri, 17 August 2012 03:51]

Report message to a moderator

Re: ORACLE Text Search -DEFINESCORE with COMPLETION [message #563911 is a reply to message #563802] Fri, 17 August 2012 16:23 Go to previous message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
It looks like Roger Ford already answered this on the OTN Text forum:

Previous Topic: Multi-lingual searches
Next Topic: Text search to eliminate "?" using Contains Clause
Goto Forum:

Current Time: Sun Aug 14 16:49:06 CDT 2022