ALL_QUEUE_SUBSCRIBERS returns the list of subscribers that the current user has privilege to dequeue from.
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 |