|Oracle Text Reference
Part Number A90121-01
CONTAINS Query Operators, 24 of 28
Use the translation term operator (TR) to expand a query to include all the defined foreign equivalents of the query term, the synonyms of query term, and the foreign equivalents of the synonyms.
TRSYN(term[, lang, [thes]])
Expands term to include foreign equivalents of term, the synonyms of term, and the foreign equivalents of the synonyms.
Specify the operand for this operator. term is expanded to include all the foreign language entries and synonyms defined for term in thes.
Optionally, specify which foreign language equivalents to return in the expansion. The language you specify must match the language as defined in thes. If you omit this parameter, the system expands to use all defined foreign language terms.
Optionally, specify the name of the thesaurus used to return the expansions for the specified term. The thes argument has a default value of DEFAULT. As a result, a thesaurus named DEFAULT must exist in the thesaurus tables before you can use any of the thesaurus operators.
Consider a thesaurus MY_THES with the following entries for cat:
To search for all documents that contain cat, the spanish equivalent of cat, the synonym of cat, and the spanish equivalent of lion, issue the following query:
This query expands to:
You can browse a thesaurus using procedures in the CTX_THES package.