select m.kln, m.nix, m.nsm, m.nln,
decode(BITAND(m.oac, 7), 1, 'PUBLIC',
2, 'PRIVATE',
4, 'PROTECTED',
NULL),
decode(BITAND(m.oac, 8), 8, 'YES', 0, 'NO'),
decode(BITAND(m.oac, 16), 16, 'YES', 0, 'NO'),
decode(BITAND(m.oac, 1024), 1024, 'YES', 0, 'NO'),
decode(BITAND(m.oac, 512), 512, 'YES', 0, 'NO'),
decode(BITAND(m.oac, 2048), 2048, 'YES', 0, 'NO'),
decode(BITAND(m.oac, 4096), 4096, 'YES', 0, 'NO'),
decode(BITAND(m.oac, 8192), 8192, 'YES', 0, 'NO'),
decode(BITAND(m.oac, 16384), 16384, 'YES', 0, 'NO'),
decode(BITAND(m.oac, 512 + 8192 + 16384), 0, 'CLASS',
512, 'INTERFACE',
8192, 'ANNOTATION',
16384, 'ENUM',
'??? OAC = '|| BITAND(m.oac, 512 + 8192 + 16384)),
decode(BITAND(m.oac, 7), 1, 'PUBLIC ',
2, 'PRIVATE ',
4, 'PROTECTED ',
'') ||
decode(BITAND(m.oac, 8), 8, 'STATIC ', 0, '') ||
decode(BITAND(m.oac, 16), 16, 'FINAL ', 0, '') ||
decode(BITAND(m.oac, 1024), 1024, 'ABSTRACT ', 0, '') ||
decode(BITAND(m.oac, 2048), 2048, 'STRICTFP ', 0, '') ||
decode(BITAND(m.oac, 4096), 4096, 'SYNTHETIC ', 0, '') ||
decode(BITAND(m.oac, 512 + 8192 + 16384), 0, 'CLASS',
512, 'INTERFACE',
8192, 'ANNOTATION',
16384, 'ENUM',
'??? OAC = '|| BITAND(m.oac, 512 + 8192 + 16384))
from sys.x$joxmic m
where own = userenv('SCHEMAID') and m.nix != -1
SELECT M.KLN
, M.NIX
, M.NSM
, M.NLN
,
DECODE(BITAND(M.OAC
, 7)
, 1
, 'PUBLIC'
,
2
, 'PRIVATE'
,
4
, 'PROTECTED'
,
NULL)
,
DECODE(BITAND(M.OAC
, 8)
, 8
, 'YES'
, 0
, 'NO')
,
DECODE(BITAND(M.OAC
, 16)
, 16
, 'YES'
, 0
, 'NO')
,
DECODE(BITAND(M.OAC
, 1024)
, 1024
, 'YES'
, 0
, 'NO')
,
DECODE(BITAND(M.OAC
, 512)
, 512
, 'YES'
, 0
, 'NO')
,
DECODE(BITAND(M.OAC
, 2048)
, 2048
, 'YES'
, 0
, 'NO')
,
DECODE(BITAND(M.OAC
, 4096)
, 4096
, 'YES'
, 0
, 'NO')
,
DECODE(BITAND(M.OAC
, 8192)
, 8192
, 'YES'
, 0
, 'NO')
,
DECODE(BITAND(M.OAC
, 16384)
, 16384
, 'YES'
, 0
, 'NO')
,
DECODE(BITAND(M.OAC
, 512 + 8192 + 16384)
, 0
, 'CLASS'
,
512
, 'INTERFACE'
,
8192
, 'ANNOTATION'
,
16384
, 'ENUM'
,
'??? OAC = '|| BITAND(M.OAC
, 512 + 8192 + 16384))
,
DECODE(BITAND(M.OAC
, 7)
, 1
, 'PUBLIC '
,
2
, 'PRIVATE '
,
4
, 'PROTECTED '
,
'') ||
DECODE(BITAND(M.OAC
, 8)
, 8
, 'STATIC '
, 0
, '') ||
DECODE(BITAND(M.OAC
, 16)
, 16
, 'FINAL '
, 0
, '') ||
DECODE(BITAND(M.OAC
, 1024)
, 1024
, 'ABSTRACT '
, 0
, '') ||
DECODE(BITAND(M.OAC
, 2048)
, 2048
, 'STRICTFP '
, 0
, '') ||
DECODE(BITAND(M.OAC
, 4096)
, 4096
, 'SYNTHETIC '
, 0
, '') ||
DECODE(BITAND(M.OAC
, 512 + 8192 + 16384)
, 0
, 'CLASS'
,
512
, 'INTERFACE'
,
8192
, 'ANNOTATION'
,
16384
, 'ENUM'
,
'??? OAC = '|| BITAND(M.OAC
, 512 + 8192 + 16384))
FROM SYS.X$JOXMIC M
WHERE OWN = USERENV('SCHEMAID')
AND M.NIX != -1
|
|
|