Dynamic Query Script to create public synonym and private synonym in database

Please use the below query to generate the script and run accordingly.

Public Synonym:

——————–
select ‘create or replace public synonym ‘||table_name||’ for ‘||owner||’.’||table_name||’;’ from dba_tables where owner=’QA’;

Private Synonym:

———————-

select ‘create or replace synonym ‘||table_name||’ for ‘||owner||’.’||table_name||’;’ from dba_tables where owner=’USER’;