I have question on Oracle Text:
I am using Text Search on a table. It's a simple search.
The text index is on a "Keywords" column.
In this column we simply define comma separated keywords such as ....
When it is searched on word "Saving" all the 3 rows gets displayed with same SCORE. But I want to display the ORDER based on following condition ....
If the word is "checking" then citibank2.com should be on Top of the list
If the word is "saving" then citibank1.com should be on Top of the list
I mean i should get different SCORE for a row based on the keyword.
One simple solution is to repeat the word e.g. saving,saving.
this will get more score for that row. But this is not feasible ...
Is there any syntax to get the output in the order that i want
AFAIK the only way to achieve that is to repeat the word. BTW, how would you want the index to know which row should have a higher score for "saving" if it occurs the same time in every row ? IMO : simply impossible, so just repeat the word if you want a row to score better for this very word.
HTH & Regards,
ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .
>>What's the rationale behind this ranking? What's the distinquishing factor? For example, should citibank1.com be on top for keyword "saving" because 1 is less than 2 ?
Rationale: both the results citibank1.com and citibank2.com will have some content related to word "saving" but citibank1.com has more relavance for the word "saving" than other result Or I just want the user to see the citibank1.com before citibank2.com based on the importance. So I would like to show it on Top in the Order of results.