VIEW: SYS.KU$_ASSOC_VIEW

Source

View Text - Preformatted

select '1','0',
        a.obj#,
        value(so),
        a.property,
        (select c.name from  sys.col$ c where c.obj# = a.obj# and
           c.intcol# = a.intcol#),
        (select value(ss) from ku$_schemaobj_view ss where
                   ss.obj_num = a.statstype#),
        NVL(a.default_selectivity, 0), NVL(a.default_cpu_cost, 0),
        NVL(a.default_io_cost, 0), NVL(a.default_net_cost, 0),
        a.interface_version#, a.spare2
   from  sys.ku$_schemaobj_view so,
         sys.association$ a
   where   a.obj# =so.obj_num
         AND (SYS_CONTEXT('USERENV','CURRENT_USERID')=0  or
              EXISTS ( SELECT * FROM sys.session_roles
                      WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, A.OBJ#
, VALUE(SO)
, A.PROPERTY
, (SELECT C.NAME
FROM SYS.COL$ C
WHERE C.OBJ# = A.OBJ# AND C.INTCOL# = A.INTCOL#)
, (SELECT VALUE(SS)
FROM KU$_SCHEMAOBJ_VIEW SS WHERE SS.OBJ_NUM = A.STATSTYPE#)
, NVL(A.DEFAULT_SELECTIVITY
, 0)
, NVL(A.DEFAULT_CPU_COST
, 0)
, NVL(A.DEFAULT_IO_COST
, 0)
, NVL(A.DEFAULT_NET_COST
, 0)
, A.INTERFACE_VERSION#
, A.SPARE2
FROM SYS.KU$_SCHEMAOBJ_VIEW SO
, SYS.ASSOCIATION$ A
WHERE A.OBJ# =SO.OBJ_NUM
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID')=0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))