Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_QUEUE_SUBSCRIBERS

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

Related Views

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
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(24)   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)