VIEW: SYS.INT$DBA_SYNONYMS

Source

View Text - Preformatted

select u.name, o.name, s.owner, s.name, s.node,
   decode(bitand(o.flags, 196608), 65536, 1, 131072, 1, 0),
   to_number(sys_context('USERENV', 'CON_ID'))
from sys.user$ u, sys.syn$ s, sys."_CURRENT_EDITION_OBJ" o
where o.obj# = s.obj#
  and o.type# = 5
  and o.owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, S.OWNER
, S.NAME
, S.NODE
, DECODE(BITAND(O.FLAGS
, 196608)
, 65536
, 1
, 131072
, 1
, 0)
, TO_NUMBER(SYS_CONTEXT('USERENV'
, 'CON_ID')) FROM SYS.USER$ U
, SYS.SYN$ S
, SYS."_CURRENT_EDITION_OBJ" O WHERE O.OBJ# = S.OBJ#
AND O.TYPE# = 5
AND O.OWNER# = U.USER#