# Find Documents by Search Term Examples for Oracle

Below are examples on how to find documents by Search Term using the Oracle Database:

insurance

Will return documents that contain insurance.

review insurance

Will return documents that contain review insurance.

about(insurance)

Will return documents about insurance.

The about operator supports single words, phrases, and can be combined with other operators, such as AND, OR, or NOT. Any query operators included in a phrase will be ignored; however, you can use other operators, such as AND, OR, or NOT to combine ABOUT queries with word queries.

about(insurance) and banking

Will return documents about insurance, and banking.

about(insurance) and about(banking)

Will return documents about insurance, and about banking.

about(insurance) not about(homeowners)

Will return documents about insurance, and not about homeowners.

auto and home or auto & home

Will return documents that contain auto and home.

maine equiv vermont is a new england state or maine=vermont is a new england state

Will return documents that contain either the phrase; maine is a new england state, or vermont is a new england state.

?product

Will return documents that match a fuzzy expansion of product.

insurance not auto or insurance ~ auto

Will return documents that contain insurance and not auto

cars | trains or cars or trains

Will return documents that contain cars or trains.

!edgartown

Will return documents that sound like edgartown.

$produce

Will return documents that contain the same root word as produce.

grocer%

Will return documents that contain the term, beginning with grocer.

_rain

Will return documents that contain the term, ending in rain.

Notes on special characters:

- % is a multiple wild card character;

- _ is a single wild card character;

- Parenthesis characters () can be used to group terms and operators;

- Braces {} can be used to escape a string of characters or symbols;

- A forward slash / can be used to escape a single character.

- Common characters, such as – (dash) and & that are part of a string, need to be escaped. For example, 2009-10-01 needs to be specified as 2009/10/01. With the BASIC_LEXER, a print-join attribute is used requiring any – (dash) in a string to be escaped with an _ (underscore). For example, a 2009-10-01 needs to be specified as 2009_10_01.