VIEW: SYS.KU$_SYNONYM_VIEW

Source

View Text - Preformatted

select '1','0',
         s.obj#, value(o),
         -- syn_long_name defaults to name
         nvl((select j.longdbcs from sys.javasnm$ j where j.short = o.name),
             o.name),
         s.node, s.owner, s.name,
         (select j.longdbcs from sys.javasnm$ j where j.short = s.name)
  from  sys.ku$_edition_schemaobj_view o, sys.syn$ s
  where s.obj# = o.obj_num AND
         (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0) OR
                o.owner_name='PUBLIC' or
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, S.OBJ#
, VALUE(O)
, -- SYN_LONG_NAME DEFAULTS TO NAME NVL((SELECT J.LONGDBCS
FROM SYS.JAVASNM$ J
WHERE J.SHORT = O.NAME)
, O.NAME)
, S.NODE
, S.OWNER
, S.NAME
, (SELECT J.LONGDBCS
FROM SYS.JAVASNM$ J
WHERE J.SHORT = S.NAME)
FROM SYS.KU$_EDITION_SCHEMAOBJ_VIEW O
, SYS.SYN$ S
WHERE S.OBJ# = O.OBJ_NUM AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR O.OWNER_NAME='PUBLIC' OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))