VIEW: CTXSYS.CTX_THES_PHRASES

Source

View Text - Preformatted

select ths_name     thp_thesaurus,
          thp_phrase   thp_phrase,
          thp_qualify  thp_qualifier,
          thp_note     thp_scope_note
     from dr$ths, dr$ths_phrase
    where thp_thsid = ths_id
    order by thp_thsid, thp_phrase, thp_qualify

View Text - HTML Formatted

SELECT THS_NAME THP_THESAURUS
, THP_PHRASE THP_PHRASE
, THP_QUALIFY THP_QUALIFIER
, THP_NOTE THP_SCOPE_NOTE
FROM DR$THS
, DR$THS_PHRASE
WHERE THP_THSID = THS_ID ORDER BY THP_THSID
, THP_PHRASE
, THP_QUALIFY