Cacher is the code snippet organizer for pro developers

begin
  for i in (select object_name
              from user_objects
             where OBJECT_TYPE = 'FUNCTION') loop
    execute immediate 'create or replace public synonym ' || i.object_name ||
                      ' for recife90.' || i.object_name;
  end loop;
end;
/