generate 'create or replace public synonym' statement after export oracle database

SELECT 'CREATE or replace PUBLIC SYNONYM ' || synonym_name || ' FOR '|| table_owner || '.' || table_name || ';' cmd FROM dba_synonyms WHERE TABLE_OWNER in ('A','B','C') and owner='PUBLIC';