Stellent Content Server, Руководство пользователя

Страница: 76 / 198

5-28 Stellent Content Server User Guide
Finding Files
Oracle Database Full-Text Search Options
This section includes these topics:
❖
Oracle Database Full-Text Wildcards (page 5-28)
❖
Oracle Database Full-Text Search Operators (page 5-28)
Oracle Database Full-Text Wildcards
A wildcard substitutes for unknown or unpredictable characters in the search term.
The following wildcard can be used in Oracle database full-text search fields:
❖
A percent underscore (%_) equals zero or more alphanumeric characters.
Oracle Database Full-Text Search Operators
The following operators can be used to refine your Oracle database full-text search
expression.
ISABOUT(term1,
term2)[method]
Finds content items that contain the
specified terms and ranks them
based on the specified method.
ISABOUT(address, name) returns
items containing both address and
name, and ranks the results based
on how well they meet the criteria
specified in the ranking method.
“PREFIX*” Finds content items that contain the
term specified between the quotes
as a prefix to the wildcard.
“form*” returns content items that
contain words with form as a
prefix, for example, forms, formal,
formula, but not words with form
as a substring, such as inform,
uniform, or reformation.
Note: The * wildcard can be used in full-text searches only when following a prefix.
Operator Description Example
Note: For clarity, the operators are shown in upper case, but they can be in lower case
as well.