Index: openacs-4/packages/dotlrn/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/Attic/index-oracle.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/dotlrn/www/index-oracle.xql	29 Mar 2002 19:38:26 -0000	1.6
+++ openacs-4/packages/dotlrn/www/index-oracle.xql	28 Apr 2002 04:08:42 -0000	1.7
@@ -3,10 +3,16 @@
 <queryset>
 <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-<fullquery name="select_classes">
-<querytext>
-select class_key, pretty_name, package_id from dotlrn_classes, dotlrn_community_types where dotlrn_community_types.community_type=dotlrn_classes.class_key order by class_key
-</querytext>
-</fullquery>
+    <fullquery name="select_classes">
+        <querytext>
+            select dotlrn_classes.class_key,
+                   dotlrn_community_types.pretty_name,
+                   dotlrn_community_types.package_id
+            from dotlrn_classes,
+                 dotlrn_community_types
+            where dotlrn_community_types.community_type = dotlrn_classes.class_key
+            order by dotlrn_classes.class_key
+        </querytext>
+    </fullquery>
 
 </queryset>