Difference between revisions of "IX.AQ$ STREAMS QUEUE TABLE S (table)"

From dbscript Online Help
Jump to: navigation, search
 
Line 103: Line 103:
 
| "QUEUE_NAME" IS NOT NULL
 
| "QUEUE_NAME" IS NOT NULL
 
|  
 
|  
|}
 
 
=== Dependencies ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
| '''Reference Type
 
| '''Object Type
 
| '''Referencing Object
 
 
|- valign="top"
 
| Select
 
| View
 
| [[IX.AQ$STREAMS_QUEUE_TABLE_R_(view)|IX.AQ$STREAMS_QUEUE_TABLE_R]]
 
 
|- valign="top"
 
| Select
 
| View
 
| [[IX.AQ$STREAMS_QUEUE_TABLE_S_(view)|IX.AQ$STREAMS_QUEUE_TABLE_S]]
 
 
 
|}
 
|}

Latest revision as of 10:34, 27 August 2011

wikibot[edit]

Table IX.AQ$_STREAMS_QUEUE_TABLE_S

Columns[edit]

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[edit]

Primary Key Columns
SYS_C005070 SUBSCRIBER_ID

Check Constraints[edit]

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