VIEW: SYS.USER_JAVA_NCOMPS

Source

View Text - Preformatted

select /*+ no_cartesian(t) ordered use_nl(o t) */ nvl(j.longdbcs, o.name),
       t.joxftncompsource,
       t.joxftncompinitializer,
       t.joxftncomplibraryfile,
       t.joxftncomplibrary
from sys.javasnm$ j, sys.obj$ o, sys.x$joxobj t
where o.obj# = t.joxftobn
  and o.type# = 29
  and o.owner# = userenv('SCHEMAID')
  and j.short(+) = o.name

View Text - HTML Formatted

SELECT /*+ NO_CARTESIAN(T) ORDERED USE_NL(O T) */ NVL(J.LONGDBCS
, O.NAME)
, T.JOXFTNCOMPSOURCE
, T.JOXFTNCOMPINITIALIZER
, T.JOXFTNCOMPLIBRARYFILE
, T.JOXFTNCOMPLIBRARY FROM SYS.JAVASNM$ J
, SYS.OBJ$ O
, SYS.X$JOXOBJ T WHERE O.OBJ# = T.JOXFTOBN
AND O.TYPE# = 29
AND O.OWNER# = USERENV('SCHEMAID')
AND J.SHORT(+) = O.NAME