ALL_STREAMS_MESSAGE_CONSUMERS

ALL_STREAMS_MESSAGE_CONSUMERS displays information about the Streams messaging clients accessible to the current user.

Related View

DBA_STREAMS_MESSAGE_CONSUMERS displays information about all Streams messaging clients in the database.

Column	Datatype	NULL	Description
`STREAMS_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the messaging client
`QUEUE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the queue
`QUEUE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the queue
`RULE_SET_NAME`	`VARCHAR2(30)`		Name of the positive rule set
`RULE_SET_OWNER`	`VARCHAR2(30)`		Owner of the positive rule set
`NEGATIVE_RULE_SET_NAME`	`VARCHAR2(30)`		Name of the negative rule set
`NEGATIVE_RULE_SET_OWNER`	`VARCHAR2(30)`		Owner of the negative rule set
`NOTIFICATION_TYPE`	`VARCHAR2(9)`		Type of the notification action: `PROCEDURE` `MAIL` `HTTP`
`NOTIFICATION_ACTION`	`VARCHAR2(256)`		Notification action
`NOTIFICATION_CONTEXT`	`ANYDATA`		Context for the notification action