Oracle Text Reference Release 9.0.1 Part Number A90121-01 |
|
CONTAINS Query Operators, 19 of 28
Use the stem ($) operator to search for terms that have the same linguistic root as the query term.
The Oracle Text stemmer, licensed from Xerox Corporation's XSoft Division, supports the following languages: English, French, Spanish, Italian, German, and Dutch.
Syntax | Description |
---|---|
$term |
Expands a query to include all terms having the same stem or root word as the specified term. |
Input | Expands To |
---|---|
$scream |
scream screaming screamed |
$distinguish |
distinguish distinguished distinguishes |
$guitars |
guitars guitar |
$commit |
commit committed |
$cat |
cat cats |
$sing |
sang sung sing |
If stem returns a word designated as a stopword, the stopword is not included in the query or highlighted by CTX_QUERY.HIGHLIGHT or CTX_QUERY.MARKUP.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|