DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_QUEUE_SUBSCRIBERS

Object Details
Object Name: CDB_QUEUE_SUBSCRIBERS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

queue subscribers in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes owner of the queue
QUEUE_NAME VARCHAR2 (128) Yes name of the queue
QUEUE_TABLE VARCHAR2 (128) Yes name of the queue table
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
RULE CLOB (4000)
rule condition for the subscriber
DELIVERY_MODE VARCHAR2 (22)
message delivery mode for the subscriber
IF_NONDURABLE_SUBSCRIBER VARCHAR2 (3)
QUEUE_TO_QUEUE VARCHAR2 (5)
whether the subscriber is a queue to queue subscriber
SUBSCRIBER_ID NUMBER

id of subscriber
POS_BITMAP NUMBER

position of subscriber in the bitmap
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


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 SYS.CDB_QUEUE_SUBSCRIBERS;

Dependencies

[top of page]

SYS.CDB_QUEUE_SUBSCRIBERS does not reference any database object

SYS.CDB_QUEUE_SUBSCRIBERS is referenced by following:

SchemaPUBLIC
SynonymCDB_QUEUE_SUBSCRIBERS