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


VIEW: SYS.V_$AQ_NONDUR_SUBSCRIBER

Object Details
Object Name: V_$AQ_NONDUR_SUBSCRIBER
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
QUEUE_ID NUMBER

SUBSCRIBER_ID NUMBER

SUBSCRIBER_NAME VARCHAR2 (30)
RULE_CONDITION VARCHAR2 (4000)
TRANSFORMATION_OWNER VARCHAR2 (30)
TRANSFORMATION_NAME VARCHAR2 (30)
CREATION_TIME TIMESTAMP(1) WITH TIME ZONE (20)
FLAGS NUMBER

SUBSCRIBER_TYPE NUMBER

BITPOS NUMBER

CON_ID NUMBER

Query Text

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


SELECT QUEUE_ID
,      SUBSCRIBER_ID
,      SUBSCRIBER_NAME
,      RULE_CONDITION
,      TRANSFORMATION_OWNER
,      TRANSFORMATION_NAME
,      CREATION_TIME
,      FLAGS
,      SUBSCRIBER_TYPE
,      BITPOS
,      CON_ID
FROM SYS.V_$AQ_NONDUR_SUBSCRIBER;

Dependencies

[top of page]

SYS.V_$AQ_NONDUR_SUBSCRIBER references the following:

SYS.V_$AQ_NONDUR_SUBSCRIBER is referenced by following:

SchemaPUBLIC
SynonymV$AQ_NONDUR_SUBSCRIBER