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#