1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
  4. ALL_QUEUE_SUBSCRIBERS

3.20 ALL_QUEUE_SUBSCRIBERS

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

Related Views

  • DBA_QUEUE_SUBSCRIBERS displays the list of subscribers on all queues in the database.

  • USER_QUEUE_SUBSCRIBERS displays 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(128)

NOT NULL

Owner of the queue

QUEUE_NAME

VARCHAR2(128)

NOT NULL

Name of the queue

QUEUE_TABLE

VARCHAR2(128)

NOT NULL

Name of the queue table on which the queue is defined

CONSUMER_NAME

VARCHAR2(512)

Name of the subscriber

ADDRESS

VARCHAR2(1024)

Address of the subscriber

PROTOCOL

NUMBER

Protocol of the subscriber

TRANSFORMATION

VARCHAR2(61)

Transformation for the subscriber

RULE

CLOB

Rule condition for the subscriber

DELIVERY_MODE

VARCHAR2(22)

Message delivery mode for the subscriber:

  • PERSISTENT

  • BUFFERED

  • PERSISTENT_OR_BUFFERED

IF_NONDURABLE_SUBSCRIBER

VARCHAR2(3)

Indicates whether the subscriber is a non-durable subscriber (YES) or not (NO)

QUEUE_TO_QUEUE

VARCHAR2(5)

Indicates whether the subscriber is a queue-to-queue subscriber (TRUE) or not (FALSE)

SUBSCRIBER_ID

NUMBER

ID of the subscriber

POS_BITMAP

NUMBER

Position of the subscriber in the bitmap

See Also: