VIEW: SYS.KU$_FIND_SGCOL_VIEW

Source

View Text - Preformatted

select  u.name, o.name, c.name, c.default$
  from    sys.col$ c, sys.obj$ o, user$ u
  where   c.obj# = o.obj# and o.owner# = u.user# and default$ IS NOT NULL 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
, C.DEFAULT$
FROM SYS.COL$ C
, SYS.OBJ$ O
, USER$ U
WHERE C.OBJ# = O.OBJ#
AND O.OWNER# = U.USER#
AND DEFAULT$ IS NOT NULL AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))