VIEW: CTXSYS.CTX_INDEX_VALUES

Source

View Text - Preformatted

select /*+ ORDERED */
       u.name    ixv_index_owner,
       idx_name  ixv_index_name,
       cla_name  ixv_class,
       obj_name  ixv_object,
       oat_name  ixv_attribute,
       decode(oat_datatype, 'B', decode(ixv_value, 1, 'YES', 'NO'),
         nvl(oal_label, ixv_value)) ixv_value
from dr$index,
     sys.user$ u,
     dr$index_value,
     dr$object_attribute,
     dr$object,
     dr$class,
     dr$object_attribute_lov
where ixv_value = nvl(oal_value, ixv_value)
  and oat_id = oal_oat_id (+)
  and oat_system = 'N'
  and oat_cla_id = obj_cla_id
  and oat_obj_id = obj_id
  and cla_system = 'N'
  and oat_cla_id = cla_id
  and ixv_oat_id = oat_id
  and idx_id     = ixv_idx_id
  and idx_owner# = u.user#

View Text - HTML Formatted

SELECT /*+ ORDERED */ U.NAME IXV_INDEX_OWNER
, IDX_NAME IXV_INDEX_NAME
, CLA_NAME IXV_CLASS
, OBJ_NAME IXV_OBJECT
, OAT_NAME IXV_ATTRIBUTE
, DECODE(OAT_DATATYPE
, 'B'
, DECODE(IXV_VALUE
, 1
, 'YES'
, 'NO')
, NVL(OAL_LABEL
, IXV_VALUE)) IXV_VALUE FROM DR$INDEX
, SYS.USER$ U
, DR$INDEX_VALUE
, DR$OBJECT_ATTRIBUTE
, DR$OBJECT
, DR$CLASS
, DR$OBJECT_ATTRIBUTE_LOV WHERE IXV_VALUE = NVL(OAL_VALUE
, IXV_VALUE)
AND OAT_ID = OAL_OAT_ID (+)
AND OAT_SYSTEM = 'N'
AND OAT_CLA_ID = OBJ_CLA_ID
AND OAT_OBJ_ID = OBJ_ID
AND CLA_SYSTEM = 'N'
AND OAT_CLA_ID = CLA_ID
AND IXV_OAT_ID = OAT_ID
AND IDX_ID = IXV_IDX_ID
AND IDX_OWNER# = U.USER#