DELETE FROM objects
WHERE name in (SELECT name from objects START WITH name = 'прилади'
    CONNECT BY PRIOR object_id = parent_id);