VIEW: CTXSYS.CTX_STOPWORDS

Source

View Text - Preformatted

select
  u.name         spw_owner,
  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, sys.user$ u
where spl_id = spw_spl_id
  and spl_owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME SPW_OWNER
, 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
, SYS.USER$ U WHERE SPL_ID = SPW_SPL_ID
AND SPL_OWNER# = U.USER#