VIEW: SYS.ALL_EVALUATION_CONTEXT_VARS

Source

View Text - Preformatted

SELECT /*+ all_rows */
       u.name, o.name, ecv.var_name, ecv.var_type, ecv.var_val_func,
       ecv.var_mthd_func
FROM   rec_var$ ecv, obj$ o, user$ u
WHERE  ecv.ec_obj# = o.obj# and
       (o.owner# in (USERENV('SCHEMAID'), 1 /* PUBLIC */) or
        o.obj# in (select oa.obj# from sys.objauth$ oa
                   where grantee# in (select kzsrorol from x$kzsro)) or
        exists (select null from v$enabledprivs where priv_number in (
                 -246, /* create any evaluation context */
                 -247, /* alter any evaluation context */
                 -248, /* drop any evaluation context */
                 -249  /* execute any evaluation context */))) and
       o.owner# = u.user#

View Text - HTML Formatted

SELECT /*+ ALL_ROWS */ U.NAME
, O.NAME
, ECV.VAR_NAME
, ECV.VAR_TYPE
, ECV.VAR_VAL_FUNC
, ECV.VAR_MTHD_FUNC FROM REC_VAR$ ECV
, OBJ$ O
, USER$ U WHERE ECV.EC_OBJ# = O.OBJ# AND (O.OWNER# IN (USERENV('SCHEMAID')
, 1 /* PUBLIC */) OR O.OBJ# IN (SELECT OA.OBJ#
FROM SYS.OBJAUTH$ OA
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)) OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN ( -246
, /* CREATE ANY EVALUATION CONTEXT */ -247
, /* ALTER ANY EVALUATION CONTEXT */ -248
, /* DROP ANY EVALUATION CONTEXT */ -249 /* EXECUTE ANY EVALUATION CONTEXT */))) AND O.OWNER# = U.USER#