oracle8.1.6 select s.segment_name, s.group_id, acs_rel_type.role_pretty_plural(r.role_two) as role_pretty_plural from rel_segments s, acs_rel_types r where s.segment_id = :segment_id and s.rel_type = r.rel_type