oracle8.1.6 select object_type as ancestor_rel_type from acs_object_types where supertype = 'relationship' and object_type in ( select object_type from acs_object_types start with object_type = :add_with_rel_type connect by object_type = prior supertype )