How to search for "/" (slash) within contains operator in Oracle text?

Jun 28, 2023 7:39PM

Oracle EE19c

I added the forward slash to LEXER , PRINTJOINS and created context index using this lexer.

What is the correct way to search the "/" within contains?

If I use : WHERE Contains(name, '%/%') > 0

it returns all records. Why? Is '/' a wildcard and should be escaped?

But if I add a character to search string (eg a space) such as ( '%/ %' , %/b%, '%m/%')

it returns correctly.

However , I can't get the result , if the actual column value is only a single slash '/'

Oracle Text (MOSC)