VIEW: SYS.DBA_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

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