How about: select * from MY_TABLE where CONTAINS(MY_COL, regexp_replace('*abc*', '([^*])', '\\\1')) > 0 ...
For future users who face a similar problem. SQLDeveloper has somehow invalidated my INDEX, I simply navigated to the INDEX tab, right clicked and selected "Rebuild". Doing this re-validated the INDEX and the code now works as expected....
OK, I Solved that Issue. suppose I find 2 terms out of 3, the score will be 67 which means ( 2/3=67 ) this is the default behavior of oracle text scoring alg. so I derived an equation to find the number of occurrences (i.e number of terms in query...