VIEW: SYS.KU$_PART_COL_NAMES_VIEW

Source

View Text - Preformatted

SELECT  u.name, o.name, c.name
  FROM    user$ u, obj$ o, sys.col$ c, partcol$ pc
  WHERE   pc.obj#=c.obj# and
          pc.intcol#=c.intcol# and
          pc.obj# = o.obj# and
          o.owner# = u.user# and
          (SYS_CONTEXT('USERENV','CURRENT_USERID') in (o.owner#, 0) OR
          EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='SELECT_CATALOG_ROLE' ))
UNION ALL
  SELECT  u.name, o.name, c.name
  FROM    user$ u, obj$ o, sys.col$ c, subpartcol$ sc
  WHERE   sc.obj#=c.obj# and
          sc.intcol#=c.intcol# and
          sc.obj# = o.obj# and
          o.owner# = u.user# 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
FROM USER$ U
, OBJ$ O
, SYS.COL$ C
, PARTCOL$ PC
WHERE PC.OBJ#=C.OBJ# AND PC.INTCOL#=C.INTCOL# AND PC.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' )) UNION ALL SELECT U.NAME
, O.NAME
, C.NAME
FROM USER$ U
, OBJ$ O
, SYS.COL$ C
, SUBPARTCOL$ SC
WHERE SC.OBJ#=C.OBJ# AND SC.INTCOL#=C.INTCOL# AND SC.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))