oracle8.1.6 select s.segment_id, s.segment_name, s.group_id, acs_object.name(s.group_id) as group_name, s.rel_type, acs_object_type.pretty_name(r.rel_type) as rel_type_pretty_name, 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