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
ganesh_jadhav0509
Messages: 74
Registered: May 2007
Location: Chester
Member

Hi,

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...

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


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?

Regards

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: 9077
Registered: November 2002
Location: California, USA
Senior Member
It looks like Roger Ford already answered this on the OTN Text forum:

https://forums.oracle.com/forums/thread.jspa?threadID=2428552&tstart=0
Previous Topic: Multi-lingual searches
Next Topic: Text search to eliminate "?" using Contains Clause
Goto Forum:
  


Current Time: Thu Mar 28 17:16:59 CDT 2024