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

VIEW: SYS.USER_SUBSCR_REGISTRATIONS

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

All subscription registrations created by the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
REG_ID NUMBER

SUBSCRIPTION_NAME VARCHAR2 (128) Yes
LOCATION_NAME VARCHAR2 (256) Yes
USER# NUMBER
Yes
USER_CONTEXT RAW (128)
CONTEXT_SIZE NUMBER

NAMESPACE VARCHAR2 (9)
Subscription namespace
PRESENTATION VARCHAR2 (7)
Presentation of notification
VERSION VARCHAR2 (8)
Version
STATUS VARCHAR2 (8)
Status of registration
ANY_CONTEXT ANYDATA (4392)
CONTEXT_TYPE NUMBER

QOSFLAGS VARCHAR2 (64)
Quality of service of registration
PAYLOAD_CALLBACK VARCHAR2 (4000)
TIMEOUT TIMESTAMP(6) (11)
REG_TIME TIMESTAMP(6) WITH TIME ZONE (13)
NTFN_GROUPING_CLASS VARCHAR2 (4)
Grouping class
NTFN_GROUPING_VALUE NUMBER

Grouping value
NTFN_GROUPING_TYPE VARCHAR2 (7)
Grouping type
NTFN_GROUPING_START_TIME TIMESTAMP(6) WITH TIME ZONE (13)
Grouping start time
NTFN_GROUPING_REPEAT_COUNT VARCHAR2 (40)
Grouping repeat count
Query Text

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


SELECT REG_ID
,      SUBSCRIPTION_NAME
,      LOCATION_NAME
,      USER#
,      USER_CONTEXT
,      CONTEXT_SIZE
,      NAMESPACE
,      PRESENTATION
,      VERSION
,      STATUS
,      ANY_CONTEXT
,      CONTEXT_TYPE
,      QOSFLAGS
,      PAYLOAD_CALLBACK
,      TIMEOUT
,      REG_TIME
,      NTFN_GROUPING_CLASS
,      NTFN_GROUPING_VALUE
,      NTFN_GROUPING_TYPE
,      NTFN_GROUPING_START_TIME
,      NTFN_GROUPING_REPEAT_COUNT
FROM SYS.USER_SUBSCR_REGISTRATIONS;

Dependencies

[top of page]

SYS.USER_SUBSCR_REGISTRATIONS references the following:

SchemaSYS
TYPEANYDATA
TableREG$
PL/SQL PackageSTANDARD - show dependent code
TableUSER$
SYS.USER_SUBSCR_REGISTRATIONS is referenced by following:

SchemaPUBLIC
SynonymUSER_SUBSCR_REGISTRATIONS