Oracle Text (MOSC)
MOSC Banner

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 '/'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center