Difference between revisions of "IX.AQ$STREAMS QUEUE TABLE R (view)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''view | IX.AQ$STREAMS_QUEUE_TABLE_R |- |} <pre> </pre>)
 
Line 7: Line 7:
 
|-
 
|-
 
|}
 
|}
 +
  
 
<pre>
 
<pre>
 
+
CREATE OR REPLACE SELECT queue_name QUEUE, s.name NAME , address ADDRESS , protocol PROTOCOL, rule_condition RULE, ruleset_name RULE_SET, trans_name TRANSFORMATION  FROM "AQ$_STREAMS_QUEUE_TABLE_S" s , sys.all_rules r WHERE (bitand(s.subscriber_type, 1) = 1) AND s.rule_name = r.rule_name and r.rule_owner = 'IX'  WITH READ ONLY
 
</pre>
 
</pre>

Revision as of 20:02, 24 August 2009

wikibot

view IX.AQ$STREAMS_QUEUE_TABLE_R


CREATE OR REPLACE SELECT queue_name QUEUE, s.name NAME , address ADDRESS , protocol PROTOCOL, rule_condition RULE, ruleset_name RULE_SET, trans_name TRANSFORMATION  FROM "AQ$_STREAMS_QUEUE_TABLE_S" s , sys.all_rules r WHERE (bitand(s.subscriber_type, 1) = 1) AND s.rule_name = r.rule_name and r.rule_owner = 'IX'  WITH READ ONLY