select ths_name thp_thesaurus,
thp_phrase thp_phrase,
thp_qualify thp_qualifier,
thp_note thp_scope_note
from dr$ths_phrase, dr$ths
where thp_thsid = ths_id
and ths_owner# = userenv('SCHEMAID')
order by thp_thsid, thp_phrase, thp_qualify
SELECT THS_NAME THP_THESAURUS
,
THP_PHRASE THP_PHRASE
,
THP_QUALIFY THP_QUALIFIER
,
THP_NOTE THP_SCOPE_NOTE
FROM DR$THS_PHRASE
, DR$THS
WHERE THP_THSID = THS_ID
AND THS_OWNER# = USERENV('SCHEMAID')
ORDER BY THP_THSID
, THP_PHRASE
, THP_QUALIFY
|
|
|