ALL_DEQUEUE_QUEUES describes all queues accessible to the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the queue |
NAME |
VARCHAR2(30) |
NOT NULL |
Name of the queue |
QUEUE_TABLE |
VARCHAR2(30) |
NOT NULL |
Name of the table in which the queue data resides |
QID |
NUMBER |
NOT NULL |
Object number of the queue |
QUEUE_TYPE |
VARCHAR2(20) |
Type of the queue | |
MAX_RETRIES |
NUMBER |
Maximum number of retries allowed when dequeuing from the queue | |
RETRY_DELAY |
NUMBER |
Time interval between retries | |
ENQUEUE_ENABLED |
VARCHAR2(7) |
Queue is enabled for enqueue | |
DEQUEUE_ENABLED |
VARCHAR2(7) |
Queue is enabled for dequeue | |
RETENTION |
VARCHAR2(40) |
Time interval that processed messages are retained in the queue | |
USER_COMMENT |
VARCHAR2(50) |
User-specified comment | |
NETWORK_NAME |
VARCHAR2(64) |
Network name |