VIEW: SYS.USER_JAVA_IMPLEMENTS

Source

View Text - Preformatted

select /*+ no_cartesian(m) ordered use_nl(o m) */ nvl(j.longdbcs, o.name), m.ifx, m.iln
from sys.javasnm$ j, sys.obj$ o, sys.x$joxmif m
where o.obj# = m.obn
  and o.type# = 29
  and o.owner# = userenv('SCHEMAID')
  and j.short(+) = o.name

View Text - HTML Formatted

SELECT /*+ NO_CARTESIAN(M) ORDERED USE_NL(O M) */ NVL(J.LONGDBCS
, O.NAME)
, M.IFX
, M.ILN FROM SYS.JAVASNM$ J
, SYS.OBJ$ O
, SYS.X$JOXMIF M WHERE O.OBJ# = M.OBN
AND O.TYPE# = 29
AND O.OWNER# = USERENV('SCHEMAID')
AND J.SHORT(+) = O.NAME