DBA Data[Home] [Help]

VIEW: SYS.USER_JAVA_ARGUMENTS

Source

View Text - Preformatted

select /*+ no_cartesian(mmd) no_cartesian(mag)  ordered use_nl(o mmd) */ mmd.kln, mmd.mix, mmd.mnm, mag.aix,
       mag.aad,
       decode(mag.abt, 10, 'int',
                     11, 'long',
                     6, 'float',
                     7, 'double',
                     4, 'boolean',
                     8, 'byte',
                     5, 'char',
                     9, 'short',
                     2, 'class',
                     NULL),
       mag.aln
from sys.x$joxfm mmd, sys.x$joxmag mag
where mmd.own = userenv('SCHEMAID')
  and mmd.mix != -1
  and mmd.mix = mag.mix
  and mmd.obn = mag.obn
View Text - HTML Formatted

SELECT /*+ NO_CARTESIAN(MMD) NO_CARTESIAN(MAG) ORDERED USE_NL(O MMD) */ MMD.KLN
, MMD.MIX
, MMD.MNM
, MAG.AIX
, MAG.AAD
, DECODE(MAG.ABT
, 10
, 'INT'
, 11
, 'LONG'
, 6
, 'FLOAT'
, 7
, 'DOUBLE'
, 4
, 'BOOLEAN'
, 8
, 'BYTE'
, 5
, 'CHAR'
, 9
, 'SHORT'
, 2
, 'CLASS'
, NULL)
, MAG.ALN FROM SYS.X$JOXFM MMD
, SYS.X$JOXMAG MAG WHERE MMD.OWN = USERENV('SCHEMAID')
AND MMD.MIX != -1
AND MMD.MIX = MAG.MIX
AND MMD.OBN = MAG.OBN