oracle8.1.6 select dotlrn_community_types.community_type, dotlrn_community_types.pretty_name, dotlrn_community_types.description, (select site_node.url(site_nodes.node_id) from site_nodes where site_nodes.object_id = dotlrn_community_types.package_id) as url from dotlrn_community_types where dotlrn_community_types.supertype = :community_type