ALL_QUEUE_SUBSCRIBERS

ALL_QUEUE_SUBSCRIBERS returns the list of subscribers that the current user has privilege to dequeue from.

Related Views

DBA_QUEUE_SUBSCRIBERS returns the list of subscribers on all queues in the database.
USER_QUEUE_SUBSCRIBERS returns the list of subscribers on queues that are under the current user's schema. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the queue
`QUEUE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the queue
`QUEUE_TABLE`	`VARCHAR2(30)`	`NOT NULL`	Name of the queue table on which the queue is defined
`CONSUMER_NAME`	`VARCHAR2(30)`		Name of the subscriber
`ADDRESS`	`VARCHAR2(1024)`		Address of the subscriber
`PROTOCOL`	`NUMBER`		Protocol of the subscriber
`TRANSFORMATION`	`VARCHAR2(61)`		Transformation for the subscriber
`DELIVERY_MODE`	`VARCHAR2(22)`		Message delivery mode for the subscriber. There are three possible modes: `PERSISTENT`, `BUFFERED`, or `PERSISTENT_OR_BUFFERED`.
`QUEUE_TO_QUEUE`	`VARCHAR2(5)`		`TRUE` if the subscriber is a queue-to-queue subscriber; `FALSE` otherwise