oracle8.1.6 select object_type from object_types start with object_type = :subtype connect by prior supertype = object_type where object_type != :substype order by level desc