VIEW: CTXSYS.CTX_USER_PREFERENCES

Source

View Text - Preformatted

select  pre_name          pre_name
       ,cla_name          pre_class
       ,obj_name          pre_object
from   dr$preference
      ,dr$object
      ,dr$class
where pre_obj_id = obj_id
  and pre_cla_id = obj_cla_id
  and obj_cla_id = cla_id
  and obj_system = 'N'
  and cla_system = 'N'
  and pre_owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT PRE_NAME PRE_NAME
, CLA_NAME PRE_CLASS
, OBJ_NAME PRE_OBJECT FROM DR$PREFERENCE
, DR$OBJECT
, DR$CLASS WHERE PRE_OBJ_ID = OBJ_ID
AND PRE_CLA_ID = OBJ_CLA_ID
AND OBJ_CLA_ID = CLA_ID
AND OBJ_SYSTEM = 'N'
AND CLA_SYSTEM = 'N'
AND PRE_OWNER# = USERENV('SCHEMAID')