|Oracle Text Reference
Part Number A90121-01
CONTAINS Query Operators, 23 of 28
Use the translation term operator (TR) to expand a query to include all defined foreign language equivalent terms.
TR(term[, lang, [thes]])
Expands term to include all the foreign equivalents that are defined for term.
Specify the operand for the translation term operator. term is expanded to include all the foreign language entries 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 and the spanish translation of cat, issue the following query:
This query expands to:
You can browse a thesaurus using procedures in the CTX_THES package.