Oracle教程 2023-02-26

Oracle 视图 ALL_QUEUE_SUBSCRIBERS 官方解释，作用，如何使用详细说明

ALL_QUEUE_SUBSCRIBERS视图可以查询出当前用户定义的归档日志信息，包括所有非系统队列、系统队列和归档队列的订阅者。可以用来查看队列订阅者的情况。

语法：
SELECT SUBSCRIBER_NAME, QUEUE_NAME, HANDLER, ENABLED FROM ALL_QUEUE_SUBSCRIBERS

用途：
使用ALL_QUEUE_SUBSCRIBERS视图查看数据库中用户定义的归档队列的订阅者信息。可以查询出每个队列的订阅者名称(SUBSCRIBER_NAME)、队列名称(QUEUE_NAME)、处理程序名称(HANDLER)以及订阅状态(ENABLED)。

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