DBA Data[Home] [Help]
Skip to content

VIEW: SYS.DBA_EVALUATION_CONTEXT_TABLES

Source

View Text - Preformatted

SELECT /*+ all_rows */
       u.name, o.name, ect.tab_alias, ect.tab_name
FROM   rec_tab$ ect, obj$ o, user$ u
WHERE  ect.ec_obj# = o.obj# and o.owner# = u.user#
View Text - HTML Formatted

SELECT /*+ ALL_ROWS */ U.NAME
, O.NAME
, ECT.TAB_ALIAS
, ECT.TAB_NAME FROM REC_TAB$ ECT
, OBJ$ O
, USER$ U WHERE ECT.EC_OBJ# = O.OBJ#
AND O.OWNER# = U.USER#