Searching for Multiple Keywords Without Using ‘AND’ in Full-Text Search with Oracle

When using full-text search with an Oracle database, you can enter the words without using an operator such as AND or OR. However, if an operator is excluded, the words are searched as if they are a phrase. For example, you could enter either of the following:

• this AND that

• this that

However, in combination with other operators, keyword search applies a strict ‘AND’ search. Therefore, the following do not work:

• a (b OR c)

• a b AND NOT c

The following expressions work:

• a OR b

• a AND b

• a AND (b OR c)

• a OR (b AND c)

• a AND b AND NOT c

• a b

• a b c