Searching on Phrases with Full-Text Oracle

In many cases, a single word is not unique enough to narrow down your search results, but a phrase of combined words might return exactly what you want. When choosing a phrase on which to search, consider the following:

For example, to find only those records with the exact word combination Davis Corporation, place the search term in quotes as follows:

“Davis Corporation”

In this example, Versatile only displays entries that contain the words "Davis Corporation" as directly contained within the double quotes. It does not find "Davis" or "Corporation" alone.

Do not use Boolean operators when searching on phrases with Oracle, otherwise they are considered part of the search phrase. For example, a search phrase like “smith and wesson” returns results that contain “smith" and "wesson” because the system reads the word “and” in the phrase as a Boolean operator. In such a case, the proper syntax would be “smith {and} wesson”.

Related Topics