Supported Oracle Text CONTAINS Query Operators for In-Memory Full Text Search

You can query for simple words and phrases using the CONTAINS operator when In-Memory full text search is enabled.

For querying a text column, only the following Oracle Text query operators are supported:

• AND

• OR

• NOT

• NEAR

For querying a JSON column, the following Oracle Text query operators are also supported:

• HASPATH

• INPATH

See Also: Oracle Text Application Developer’s Guide for more information about In-Memory full text search and JSON full text search