0

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.

Improve this question
2
  • The link to the document that you posted has the comma as the ACCUMulate operator. it has the lowest precedence, but affects the scoring of the returned items, with the higher number of possible matches returning a higher score ("cat,dog" would score something with cat and dog higher than either cat or dog on it's own)
    – Jad
    Commented Jun 25, 2021 at 11:01
  • @Jad, Bingo, I totally missed that. If you turn your comment into an answer then I will give that to you.
    – AnthonyVO
    Commented Jun 26, 2021 at 18:54

1 Answer 1

Reset to default
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

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.