VIEW: SYS.KU$_FIND_NTAB_ATTRCOL_VIEW

Source

View Text - Preformatted

select  u.name, o.name, c.name, a.name
  from    sys.col$ c, sys.obj$ o, user$ u, sys.attrcol$ a
  where   c.obj# = o.obj# and
          o.owner# = u.user# and
          c.intcol# - 1 = a.intcol# and
          a.obj# = c.obj# and
          bitand(c.property, 1056) = 1056 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 U.NAME
, O.NAME
, C.NAME
, A.NAME
FROM SYS.COL$ C
, SYS.OBJ$ O
, USER$ U
, SYS.ATTRCOL$ A
WHERE C.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND C.INTCOL# - 1 = A.INTCOL# AND A.OBJ# = C.OBJ# AND BITAND(C.PROPERTY
, 1056) = 1056 AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))