VIEW: CTXSYS.CTX_OBJECTS

Source

View Text - Preformatted

select cla_name  obj_class,
       obj_name  obj_name,
       obj_desc  obj_description
  from dr$class,
       dr$object
 where cla_id     = obj_cla_id
   and obj_system = 'N'
   and cla_system = 'N'

View Text - HTML Formatted

SELECT CLA_NAME OBJ_CLASS
, OBJ_NAME OBJ_NAME
, OBJ_DESC OBJ_DESCRIPTION
FROM DR$CLASS
, DR$OBJECT
WHERE CLA_ID = OBJ_CLA_ID
AND OBJ_SYSTEM = 'N'
AND CLA_SYSTEM = 'N'