Oracle Text: query scoring with CTXCAT index?
The score can only be accessed with a CONTENT index using a query like this

SELECT ID, TEXT,SCORE(1) FROM t WHERE CONTAINS(text, 'my query',1) &gt; 0
ORDER BY SCORE(99) DESC;


By Oracle 11 everything you can do with a CTXCAT index you can do more with a CONTENT index.  Why not use that?

Edit: The op asks if CONTENT indexes must be synced.  Yes, this is correct.  I find the time and load factor to do this is entirely acceptable for smaller records sets.  Your mileage may vary based on record size.
Further reference:


Oracle how to
Text index how to