oracle8.1.6 select pretty_name, description, dotlrn_community.url(community_id) as url from dotlrn_communities_all where archived_p = 't' order by pretty_name, description