oracle8.1.6 select t.pretty_name, t.object_type as rel_type, replace(lpad(' ', (level - 1) * 4), ' ', ' ') as indent from acs_object_types t where t.object_type not in (select s.rel_type from rel_segments s where s.group_id = :group_id) connect by prior t.object_type = t.supertype start with t.object_type in ('membership_rel', 'composition_rel') order by lower(t.pretty_name) desc select acs_group.name(:group_id) as group_name from dual