How to search for "/" (slash) within contains operator in Oracle text?
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 '/'