VIEW: CTXSYS.CTX_STOPLISTS

Source

View Text - Preformatted

select
  u.name             spl_owner,
  spl_name           spl_name,
  spl_count          spl_count,
  obj_name           spl_type
from dr$stoplist, sys.user$ u, dr$object, dr$class
where spl_owner# = u.user#
  and spl_type = obj_id
  and obj_cla_id = cla_id
  and cla_name = 'STOPLIST'

View Text - HTML Formatted

SELECT U.NAME SPL_OWNER
, SPL_NAME SPL_NAME
, SPL_COUNT SPL_COUNT
, OBJ_NAME SPL_TYPE FROM DR$STOPLIST
, SYS.USER$ U
, DR$OBJECT
, DR$CLASS WHERE SPL_OWNER# = U.USER#
AND SPL_TYPE = OBJ_ID
AND OBJ_CLA_ID = CLA_ID
AND CLA_NAME = 'STOPLIST'