VIEW: CTXSYS.CTX_THESAURI

Source

View Text - Preformatted

select u.name ths_owner,
       ths_name
  from dr$ths, sys.user$ u
 where ths_owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME THS_OWNER
, THS_NAME
FROM DR$THS
, SYS.USER$ U
WHERE THS_OWNER# = U.USER#