My Oracle Support Banner

How Do Stop Words in the Oracle Database Affect a Search That Is Done in Content Server with Oracle Text Search? (Doc ID 876691.1)

Last updated on MAY 22, 2020

Applies to:

Oracle WebCenter Content - Version 10.0 and later
Information in this document applies to any platform.


How do stopwords in the Oracle database affect a search that is done in Content Server with Oracle Text Search?

If a search is done with a stopword like "here" as the value for one field, and Public as the security group, you get all Public items back in the results. This makes sense since stopwords are thrown out of the query.

However, if you search just for the stopword in the one field with no other criteria set, you get no results back at all instead of all items returned.

Why is this?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.