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
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
|
|
|