eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: CTXSYS.CTX_USER_STOPWORDS

Source

View Text - Preformatted


select
  spl_name       spw_stoplist,
  decode(spw_type, 1, 'STOP_CLASS', 2, 'STOP_WORD', 3, 'STOP_THEME', null)
                 spw_type,
  spw_word       spw_word,
  decode(spw_language, 'ALL', null, spw_language)   spw_language,
  spw_lang_dependent   spw_lang_dependent,
  spw_pattern          spw_pattern
from dr$stoplist, dr$stopword
where spl_id = spw_spl_id
  and spl_owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT SPL_NAME SPW_STOPLIST
, DECODE(SPW_TYPE
, 1
, 'STOP_CLASS'
, 2
, 'STOP_WORD'
, 3
, 'STOP_THEME'
, NULL) SPW_TYPE
, SPW_WORD SPW_WORD
, DECODE(SPW_LANGUAGE
, 'ALL'
, NULL
, SPW_LANGUAGE) SPW_LANGUAGE
, SPW_LANG_DEPENDENT SPW_LANG_DEPENDENT
, SPW_PATTERN SPW_PATTERN FROM DR$STOPLIST
, DR$STOPWORD WHERE SPL_ID = SPW_SPL_ID
AND SPL_OWNER# = USERENV('SCHEMAID')