给所有的表建同义词

select 'create public synonym ' || table_name || ' for ' || owner || '.' || table_name || ';' from dba_tables
where owner in ('EMR','HSFX','MZGL','XTGL','YJGL','YPGL','ZYGL','RUIMEILIS') order by owner,table_name;