set heading off
set feedback off
spool drop_syns.sql
select 'DROP SYNONYM '||table_name||' ;'
   from tabs;
spool off
set heading on
set feedback on
