ORACLE - create public synonym

create public synonym [nomeTABELA] for [owner.nomeTABELA];

select 'create public synonym 'table_name' for owner.'table_name';'from dba_tables where owner = 'XYZ'