VIEW: SYS.KU$_IND_STATS_VIEW

Source

View Text - Preformatted

select  '3', '0',
          i.obj#, i.bo#,
         decode(i.type# , 8,
            (select value(sov) from ku$_schemaobj_view sov
             where sov.obj_num = dbms_metadata_util.get_anc(i.bo#)),
           (select value(sov) from ku$_schemaobj_view sov
            where sov.obj_num = i.bo#)),
          (select value(sov) from ku$_schemaobj_view sov
           where sov.obj_num = i.obj#),
          i.type#, i.property
  from    sys.obj$ o, sys.ind$ i
  where   i.obj# = o.obj# and
          (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner#, 0) OR
              EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '3'
, '0'
, I.OBJ#
, I.BO#
, DECODE(I.TYPE#
, 8
, (SELECT VALUE(SOV)
FROM KU$_SCHEMAOBJ_VIEW SOV
WHERE SOV.OBJ_NUM = DBMS_METADATA_UTIL.GET_ANC(I.BO#))
, (SELECT VALUE(SOV)
FROM KU$_SCHEMAOBJ_VIEW SOV
WHERE SOV.OBJ_NUM = I.BO#))
, (SELECT VALUE(SOV)
FROM KU$_SCHEMAOBJ_VIEW SOV
WHERE SOV.OBJ_NUM = I.OBJ#)
, I.TYPE#
, I.PROPERTY
FROM SYS.OBJ$ O
, SYS.IND$ I
WHERE I.OBJ# = O.OBJ# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))