Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 9i Text:SCORE always return the same value...
Hello all,
Why this kind of query always get the same scores?
SELECT (.7*SCORE(1) + .3*SCORE(2)), FOGVW_SEARCHCUSTOMERS.*
FROM FOGVW_SEARCHCUSTOMERS
WHERE (CONTAINS(LAST_NAME, 'fuzzy(?Azua,65,100,weight)', 1) > 0
OR CONTAINS(FIRST_NAME, 'fuzzy(?Giovanni,65,100,weight)', 2) > 0 )
ORDER BY (.5*SCORE(1) + .3*SCORE(2)) DES
TIA,
Best Regards,
Giovanni
Received on Mon Oct 14 2002 - 13:50:20 CDT