select ol_name, creator, category,
decode(bitand(flags, 1), 0, 'UNUSED', 1, 'USED'),
timestamp, version, sql_text, signature,
decode(bitand(flags, 2), 0, 'COMPATIBLE', 2, 'INCOMPATIBLE'),
decode(bitand(flags, 4), 0, 'ENABLED', 4, 'DISABLED'),
decode(bitand(flags, 8), 0, 'NORMAL', 8, 'LOCAL'),
decode(bitand(flags, 16), 0, 'NOT-MIGRATED', 16, 'MIGRATED')
from outln.ol$
SELECT OL_NAME
, CREATOR
, CATEGORY
,
DECODE(BITAND(FLAGS
, 1)
, 0
, 'UNUSED'
, 1
, 'USED')
,
TIMESTAMP
, VERSION
, SQL_TEXT
, SIGNATURE
,
DECODE(BITAND(FLAGS
, 2)
, 0
, 'COMPATIBLE'
, 2
, 'INCOMPATIBLE')
,
DECODE(BITAND(FLAGS
, 4)
, 0
, 'ENABLED'
, 4
, 'DISABLED')
,
DECODE(BITAND(FLAGS
, 8)
, 0
, 'NORMAL'
, 8
, 'LOCAL')
,
DECODE(BITAND(FLAGS
, 16)
, 0
, 'NOT-MIGRATED'
, 16
, 'MIGRATED')
FROM OUTLN.OL$
|
|
|