Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
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
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_QUEUE_SUBSCRIBERS

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