Oracle SQL - How to delete all public synonyms for a schema

drop-public-synonyms.sql

BEGIN
   FOR cur_syn IN (SELECT synonym_name
                     FROM all_synonyms
                    WHERE table_owner = 'somebody')
   LOOP
      BEGIN
         EXECUTE IMMEDIATE 'drop public synonym "' || cur_syn.synonym_name || '";';
      EXCEPTION
         WHEN OTHERS
         THEN
            DBMS_OUTPUT.PUT_LINE ('Failed to drop the public synonym ' || cur_syn.synonym_name || '!');
      END;
   END LOOP;
END;
/

Thanks for sharing. Was getting a syntax error so created a modified version here - https://gist.github.com/tremblam/038c5794ac1b70825fd2c902e8b9665e

Thanks, the link is broken now, so I made my version
https://gist.github.com/trang1/daff5c9fed567a46bbefad86e5e38d78#file-drop-public-synonyms-sql