VIEW: CTXSYS.CTX_OBJECT_ATTRIBUTES

Source

View Text - Preformatted

select cla_name      oat_class,
       obj_name      oat_object,
       oat_name      oat_attribute,
       oat_desc      oat_description,
       oat_required  oat_required,
       oat_static    oat_static,
       decode(oat_datatype,'S','STRING','I','INTEGER','B','BOOLEAN',
                           'P','PROCEDURE')
                     oat_datatype,
       oat_default   oat_default,
       oat_val_min   oat_min,
       decode(oat_datatype, 'S', null, oat_val_max) oat_max,
       decode(oat_datatype, 'S', oat_val_max, null) oat_max_length
  from dr$class,
       dr$object,
       dr$object_attribute
 where cla_id     = obj_cla_id
   and obj_cla_id = oat_cla_id
   and obj_id     = oat_obj_id
   and oat_system = 'N'
   and cla_system = 'N'

View Text - HTML Formatted

SELECT CLA_NAME OAT_CLASS
, OBJ_NAME OAT_OBJECT
, OAT_NAME OAT_ATTRIBUTE
, OAT_DESC OAT_DESCRIPTION
, OAT_REQUIRED OAT_REQUIRED
, OAT_STATIC OAT_STATIC
, DECODE(OAT_DATATYPE
, 'S'
, 'STRING'
, 'I'
, 'INTEGER'
, 'B'
, 'BOOLEAN'
, 'P'
, 'PROCEDURE') OAT_DATATYPE
, OAT_DEFAULT OAT_DEFAULT
, OAT_VAL_MIN OAT_MIN
, DECODE(OAT_DATATYPE
, 'S'
, NULL
, OAT_VAL_MAX) OAT_MAX
, DECODE(OAT_DATATYPE
, 'S'
, OAT_VAL_MAX
, NULL) OAT_MAX_LENGTH
FROM DR$CLASS
, DR$OBJECT
, DR$OBJECT_ATTRIBUTE
WHERE CLA_ID = OBJ_CLA_ID
AND OBJ_CLA_ID = OAT_CLA_ID
AND OBJ_ID = OAT_OBJ_ID
AND OAT_SYSTEM = 'N'
AND CLA_SYSTEM = 'N'