Menu
  • HOME
  • TAGS

Oracle text escaping with curly braces and wildcards

sql,oracle,oracle-text

How about: select * from MY_TABLE where CONTAINS(MY_COL, regexp_replace('*abc*', '([^*])', '\\\1')) > 0 ...

Oracle Text: CONTAINS is not returning any values, even though they exist in the index

sql,oracle,oracle-text

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....

oracle text definescore with accum

sql,oracle,oracle-text

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...