IX.AQ$ STREAMS QUEUE TABLE S (table)

From dbscript Online Help
Revision as of 07:14, 24 June 2010 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table IX.AQ$_STREAMS_QUEUE_TABLE_S

Columns

Column Data Type Nullable Default Description
SUBSCRIBER_ID NUMBER not null
QUEUE_NAME VARCHAR2(30) not null
NAME VARCHAR2(30) null
ADDRESS VARCHAR2(1024) null
PROTOCOL NUMBER null
SUBSCRIBER_TYPE NUMBER null
RULE_NAME VARCHAR2(30) null
TRANS_NAME VARCHAR2(61) null
RULESET_NAME VARCHAR2(65) null
NEGATIVE_RULESET_NAME VARCHAR2(65) null

Primary Key

Primary Key Columns
SYS_C005070 SUBSCRIBER_ID

Check Constraints

Check Constraint Expression Description
SYS_C005068 "SUBSCRIBER_ID" IS NOT NULL
SYS_C005069 "QUEUE_NAME" IS NOT NULL

Dependencies

Reference Type Object Type Referencing Object
Select View IX.AQ$STREAMS_QUEUE_TABLE_R
Select View IX.AQ$STREAMS_QUEUE_TABLE_S