DBA Data[Home] [Help]

VIEW: SYS.USER_JAVA_THROWS

Source

View Text - Preformatted

select /*+ no_cartesian(mmd) no_cartesian(mex) ordered use_nl(o mmd) */
       mmd.kln, mmd.mix, mmd.mnm, mex.xix, mex.xln
from sys.x$joxmex mex, sys.x$joxmmd mmd
where mmd.own = userenv('SCHEMAID')
  and mmd.mix != -1
  and mmd.mix = mex.mix
  and mmd.obn = mex.obn
View Text - HTML Formatted

SELECT /*+ NO_CARTESIAN(MMD) NO_CARTESIAN(MEX) ORDERED USE_NL(O MMD) */ MMD.KLN
, MMD.MIX
, MMD.MNM
, MEX.XIX
, MEX.XLN FROM SYS.X$JOXMEX MEX
, SYS.X$JOXMMD MMD WHERE MMD.OWN = USERENV('SCHEMAID')
AND MMD.MIX != -1
AND MMD.MIX = MEX.MIX
AND MMD.OBN = MEX.OBN