[Home] [Help] [Dependency Information]
Object Name: | DBA_STREAMS_MESSAGE_CONSUMERS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Streams messaging consumers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STREAMS_NAME | VARCHAR2 | (128) | Yes | Name of the consumer |
QUEUE_NAME | VARCHAR2 | (128) | Yes | Name of the queue |
QUEUE_OWNER | VARCHAR2 | (128) | Yes | Owner of the queue |
RULE_SET_NAME | VARCHAR2 | (128) | Name of the rule set | |
RULE_SET_OWNER | VARCHAR2 | (128) | Owner of the rule set | |
NEGATIVE_RULE_SET_NAME | VARCHAR2 | (128) | Name of the negative rule set | |
NEGATIVE_RULE_SET_OWNER | VARCHAR2 | (128) | Owner of the negative rule set | |
NOTIFICATION_TYPE | VARCHAR2 | (9) | Type of notification action: plsql/mailto/http | |
NOTIFICATION_ACTION | VARCHAR2 | (256) | Notification action | |
NOTIFICATION_CONTEXT | ANYDATA | (64) | Context for the notification action |
Cut, paste (and edit) the following text to query this object:
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
, NOTIFICATION_CONTEXT
FROM SYS.DBA_STREAMS_MESSAGE_CONSUMERS;
|
|
|