OraFAQ Forum: Text & interMedia » ORACLE Text Search -DEFINESCORE with COMPLETION

Home » Server Options » Text & interMedia » ORACLE Text Search -DEFINESCORE with COMPLETION (Oracle -10g)

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

ORACLE Text Search -DEFINESCORE with COMPLETION [message #563802]

Fri, 17 August 2012 03:46

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