VIEW: SYS.USER_JAVA_LAYOUTS

Source

View Text - Preformatted

select /*+ no_cartesian(m) ordered use_nl(o m) */
              nvl(j.longdbcs, o.name), m.lic, m.lnc,
              m.lfc, m.lsf,
              m.lmc, m.lsm, m.jnc
from sys.javasnm$ j, sys.obj$ o, sys.x$joxmob 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.LIC
, M.LNC
, M.LFC
, M.LSF
, M.LMC
, M.LSM
, M.JNC FROM SYS.JAVASNM$ J
, SYS.OBJ$ O
, SYS.X$JOXMOB M WHERE O.OBJ# = M.OBN
AND O.TYPE# = 29
AND O.OWNER# = USERENV('SCHEMAID')
AND J.SHORT(+) = O.NAME