select u.name, pd.timestamp,
decode(bitand(u.spare1, 1), 1,
decode(bitand(pd.flags, 1), 1, 'IMPLICIT', 'EXPLICIT'), 'NO'),
decode(bitand(u.spare1, 2), 2,
decode(bitand(pd.flags, 2), 2, 'IMPLICIT', 'EXPLICIT'), 'NO'),
decode(bitand(u.spare1, 4), 4,
decode(bitand(pd.flags, 4), 4, 'IMPLICIT', 'EXPLICIT'), 'NO'),
decode(bitand(u.spare1, 8), 8,
decode(bitand(pd.flags, 8), 8, 'IMPLICIT', 'EXPLICIT'), 'NO')
from streams$_prepare_ddl pd, user$ u
where u.user# = pd.usrid and global_flag = 0
SELECT U.NAME
, PD.TIMESTAMP
,
DECODE(BITAND(U.SPARE1
, 1)
, 1
,
DECODE(BITAND(PD.FLAGS
, 1)
, 1
, 'IMPLICIT'
, 'EXPLICIT')
, 'NO')
,
DECODE(BITAND(U.SPARE1
, 2)
, 2
,
DECODE(BITAND(PD.FLAGS
, 2)
, 2
, 'IMPLICIT'
, 'EXPLICIT')
, 'NO')
,
DECODE(BITAND(U.SPARE1
, 4)
, 4
,
DECODE(BITAND(PD.FLAGS
, 4)
, 4
, 'IMPLICIT'
, 'EXPLICIT')
, 'NO')
,
DECODE(BITAND(U.SPARE1
, 8)
, 8
,
DECODE(BITAND(PD.FLAGS
, 8)
, 8
, 'IMPLICIT'
, 'EXPLICIT')
, 'NO')
FROM STREAMS$_PREPARE_DDL PD
, USER$ U
WHERE U.USER# = PD.USRID
AND GLOBAL_FLAG = 0
|
|
|