isitdevops.com/databases

— syn_lst.sql
— mdw – simple synonym listing
set pause on
set pages 24
set pause ‘Any Key>’
col owner         form a10 wrap
col synonym_name  form a20 word wrap
col table_owner   form a10 wrap
col table_name    form a20 word wrap
col db_link       form a14 word wrap
spool syn_lst.lst
select owner
,synonym_name
,table_owner
,table_name
,db_link
from dba_synonyms
where synonym_name like upper(nvl(‘&syn_name’,’WHOOPS’)||’%’)
/
spool off
clear columns
— EOF