--  kreiranje PUBLIC SYNONYM
CONNECT HNBGASTRO/...@...

-- propusti rezultat donjeg upita 
SELECT 'CREATE PUBLIC SYNONYM '||object_name||' FOR '||'HNBGASTRO'||'.'||object_name||';'
  FROM user_objects 
 WHERE object_type in ('PACKAGE', 'TABLE', 'VIEW')
   AND object_name 
   NOT IN (SELECT synonym_name 
             FROM dba_synonyms 
            WHERE table_owner IN ('HNBGASTRO')
              AND object_name NOT LIKE 'X%') 


CONNECT HNBMISHSYS/...@..

--propustiti rezltat skripte
SELECT 'CREATE PUBLIC SYNONYM '||object_name||' FOR '||'HNBMISHSYS'||'.'||object_name||';'
  FROM user_objects 
 WHERE object_type in ('PACKAGE', 'TABLE', 'VIEW')
   AND object_name
   NOT IN (SELECT synonym_name 
             FROM dba_synonyms 
            WHERE table_owner IN ('HNBMISHSYS')
              AND object_name NOT LIKE 'X%') 
/