Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


ALL_QUEUE_SUBSCRIBERS returns 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
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