select streams_name, queue_name, queue_owner, rule_set_name, rule_set_owner,
negative_rule_set_name, negative_rule_set_owner, notification_type,
notification_action,
decode(context_type,
0, sys.anydata.ConvertRaw(user_context),
1, any_context)
from sys."_DBA_STREAMS_MSG_NOTIFICATIONS"
SELECT STREAMS_NAME
, QUEUE_NAME
, QUEUE_OWNER
, RULE_SET_NAME
, RULE_SET_OWNER
,
NEGATIVE_RULE_SET_NAME
, NEGATIVE_RULE_SET_OWNER
, NOTIFICATION_TYPE
,
NOTIFICATION_ACTION
,
DECODE(CONTEXT_TYPE
,
0
, SYS.ANYDATA.CONVERTRAW(USER_CONTEXT)
,
1
, ANY_CONTEXT)
FROM SYS."_DBA_STREAMS_MSG_NOTIFICATIONS"
|
|
|