oracle8.1.6 select group_id as community_id,group_name as pretty_name from groups