Can the Oracle-Text OR be replaced with a comma?

All we need is an easy explanation of the problem, so here it is.

I have incorporated user-accessible Oracle-Text functionality within my application and I noticed that the comma , can be used in place of OR or the pipe | character.

Searching on ‘red OR green OR blue’ returns the same results as ‘red|green|blue’ or ‘red,green,blue’.

I reviewed the Oracle-Text Contains documentation and tried my favourite search engine but I did not find any documentation to support or negate my findings and the comma , is never mentioned.

I would like to mention the comma , as an option for my users but don’t want to without some supporting documentation.

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

The link to the document that you posted has the comma as the ACCUMulate operator.

The Accumulate operator is the operator with the lowest precedence, but it affects the scoring of the returned items, with the higher number of possible matches returning a higher score

e.g. the accumulate action of cat,dog would score something with both cat and dog higher than a string with either cat xor dog in it

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply