VIEW: SYS.ALL_JAVA_IMPLEMENTS

Source

View Text - Preformatted

select /*+ no_cartesian(m) ordered use_nl(o m) */
       u.name, nvl(j.longdbcs, o.name), m.ifx, m.iln
from sys.javasnm$ j, sys.obj$ o, sys.x$joxmif m, sys.user$ u
where o.obj# = m.obn
  and o.type# = 29
  and o.owner# = u.user#
  and j.short(+) = o.name
  and
  (
    o.owner# in (userenv('SCHEMAID'), 1 /* PUBLIC */)
    or
    (
      (
        (
          o.obj# in (select obj# from sys.objauth$
                     where grantee# in (select kzsrorol from x$kzsro)
                       and privilege#  = 12 /* EXECUTE */)
        )
        or
        exists
        (
          select null from sys.sysauth$
          where grantee# in (select kzsrorol from x$kzsro)
          and
          (
            (
              /* procedure */
              (
                privilege# = -144 /* EXECUTE ANY PROCEDURE */
                or
                privilege# = -141 /* CREATE ANY PROCEDURE */
              )
            )
          )
        )
      )
    )
  )

View Text - HTML Formatted

SELECT /*+ NO_CARTESIAN(M) ORDERED USE_NL(O M) */ U.NAME
, NVL(J.LONGDBCS
, O.NAME)
, M.IFX
, M.ILN FROM SYS.JAVASNM$ J
, SYS.OBJ$ O
, SYS.X$JOXMIF M
, SYS.USER$ U WHERE O.OBJ# = M.OBN
AND O.TYPE# = 29
AND O.OWNER# = U.USER#
AND J.SHORT(+) = O.NAME AND ( O.OWNER# IN (USERENV('SCHEMAID')
, 1 /* PUBLIC */) OR ( ( ( O.OBJ# IN (SELECT OBJ#
FROM SYS.OBJAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND PRIVILEGE# = 12 /* EXECUTE */) ) OR EXISTS ( SELECT NULL
FROM SYS.SYSAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO) AND ( ( /* PROCEDURE */ ( PRIVILEGE# = -144 /* EXECUTE ANY PROCEDURE */ OR PRIVILEGE# = -141 /* CREATE ANY PROCEDURE */ ) ) ) ) ) ) )