[Home] [Help] [Dependency Information]
Object Name: | REG$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000000076C00010$$ | LOB | UNIQUE | SYSTEM | |
REG$_IDX | NORMAL | NONUNIQUE | SYSTEM |
SUBSCRIPTION_NAME
NAMESPACE LOCATION_NAME REG_ID |
REG$_T | NORMAL | NONUNIQUE | SYSTEM | TIMEOUT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUBSCRIPTION_NAME | VARCHAR2 | (128) | Yes | |
LOCATION_NAME | VARCHAR2 | (256) | Yes | |
USER# | NUMBER | Yes | ||
USER_CONTEXT | RAW | (128) | ||
CONTEXT_SIZE | NUMBER | |||
NAMESPACE | NUMBER | |||
PRESENTATION | NUMBER | |||
VERSION | NUMBER | |||
STATUS | NUMBER | |||
ANY_CONTEXT | ANYDATA | (3748) | ||
CONTEXT_TYPE | NUMBER | |||
QOSFLAGS | NUMBER | |||
PAYLOAD_CALLBACK | VARCHAR2 | (4000) | ||
TIMEOUT | TIMESTAMP(6) | (11) | ||
REG_ID | NUMBER | |||
REG_TIME | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
NTFN_GROUPING_CLASS | NUMBER | |||
NTFN_GROUPING_VALUE | NUMBER | |||
NTFN_GROUPING_TYPE | NUMBER | |||
NTFN_GROUPING_START_TIME | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
NTFN_GROUPING_REPEAT_COUNT | NUMBER | |||
GROUPING_INST_ID | NUMBER | |||
STATE | NUMBER | |||
SESSION_KEY | VARCHAR2 | (1024) |
Cut, paste (and edit) the following text to query this object:
SELECT SUBSCRIPTION_NAME
, LOCATION_NAME
, USER#
, USER_CONTEXT
, CONTEXT_SIZE
, NAMESPACE
, PRESENTATION
, VERSION
, STATUS
, ANY_CONTEXT
, CONTEXT_TYPE
, QOSFLAGS
, PAYLOAD_CALLBACK
, TIMEOUT
, REG_ID
, REG_TIME
, NTFN_GROUPING_CLASS
, NTFN_GROUPING_VALUE
, NTFN_GROUPING_TYPE
, NTFN_GROUPING_START_TIME
, NTFN_GROUPING_REPEAT_COUNT
, GROUPING_INST_ID
, STATE
, SESSION_KEY
FROM SYS.REG$;
|
|
|