CTX_THES_PHRASES

This view displays phrase information for all thesauri in the Text data dictionary. It can be queried by any user.

Column Name	Type	Description
THP_THESAURUS	VARCHAR2(30)	Thesaurus name.
THP_PHRASE	VARCHAR2(256)	Thesaurus phrase.
THP_QUALIFIER	VARCHAR2(256)	Thesaurus qualifier.
THP_SCOPE_NOTE	VARCHAR2(2000)	Thesaurus scope notes.