DBA Data[Home] [Help]

VIEW: SYS.CDB_QUEUE_SUBSCRIBERS

Source

View Text - Preformatted

SELECT "OWNER","QUEUE_NAME","QUEUE_TABLE","CONSUMER_NAME","ADDRESS","PROTOCOL","TRANSFORMATION","RULE","DELIVERY_MODE","IF_NONDURABLE_SUBSCRIBER","QUEUE_TO_QUEUE","SUBSCRIBER_ID","POS_BITMAP","CON_ID" FROM CONTAINERS("SYS"."DBA_QUEUE_SUBSCRIBERS")
View Text - HTML Formatted

SELECT "OWNER"
, "QUEUE_NAME"
, "QUEUE_TABLE"
, "CONSUMER_NAME"
, "ADDRESS"
, "PROTOCOL"
, "TRANSFORMATION"
, "RULE"
, "DELIVERY_MODE"
, "IF_NONDURABLE_SUBSCRIBER"
, "QUEUE_TO_QUEUE"
, "SUBSCRIBER_ID"
, "POS_BITMAP"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_QUEUE_SUBSCRIBERS")