IX.AQ$STREAMS QUEUE TABLE R (view) - Revision history

Bot at 09:34, 27 August 2011

2011-08-27T09:34:24Z

Bot at 05:14, 24 June 2010

2010-06-24T05:14:54Z

Bot at 07:27, 11 February 2010

2010-02-11T07:27:29Z

Bot at 19:10, 24 August 2009

2009-08-24T19:10:02Z

Bot at 19:02, 24 August 2009

2009-08-24T19:02:22Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''view | IX.AQ$STREAMS_QUEUE_TABLE_R |- |}

2009-05-02T17:07:06Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''view | IX.AQ$STREAMS_QUEUE_TABLE_R |- |} <pre> </pre>

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''view
| IX.AQ$STREAMS_QUEUE_TABLE_R
|-
|}

<pre>

</pre>

← Older revision		Revision as of 09:34, 27 August 2011
Line 12:		Line 12:
	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		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>
−
−	~~=== References ===~~
−	~~{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"~~
−	~~\|- style="background:silver"~~
−	~~\| '''Dependency Type~~
−	~~\| '''Object Type~~
−	~~\| '''Referenced Object~~
−
−	~~\|- valign="top"~~
−	~~\| Select~~
−	~~\| Table~~
−	~~\| [[IX.AQ$_STREAMS_QUEUE_TABLE_S_(table)\|IX.AQ$_STREAMS_QUEUE_TABLE_S]]~~
−
−	\|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''View
 | IX.AQ$STREAMS_QUEUE_TABLE_R
 |}
 === Source ===
@@ Line 22: / Line 20: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Select
 | Table

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''view
+| '''View
 | IX.AQ$STREAMS_QUEUE_TABLE_R
 |-
@@ Line 9: / Line 9: @@
 <pre>
 CREATE OR REPLACE VIEW IX.AQ$STREAMS_QUEUE_TABLE_R AS
 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>

@@ Line 10: / Line 10: @@
 <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
+CREATE OR REPLACE VIEW IX.AQ$STREAMS_QUEUE_TABLE_R AS
 </pre>