VIEW: CTXSYS.CTX_USER_STOPLISTS

Source

View Text - Preformatted

select spl_name           spl_name,
       spl_count          spl_count,
       obj_name           spl_type
from   dr$stoplist, dr$object, dr$class
where  spl_owner# = userenv('SCHEMAID')
  and  spl_type = obj_id
  and  obj_cla_id = cla_id
  and  cla_name = 'STOPLIST'

View Text - HTML Formatted

SELECT SPL_NAME SPL_NAME
, SPL_COUNT SPL_COUNT
, OBJ_NAME SPL_TYPE FROM DR$STOPLIST
, DR$OBJECT
, DR$CLASS WHERE SPL_OWNER# = USERENV('SCHEMAID')
AND SPL_TYPE = OBJ_ID
AND OBJ_CLA_ID = CLA_ID
AND CLA_NAME = 'STOPLIST'