set heading off
spool nopara.sql
select 'alter table '||table_name||' noparallel;' from tabs;
spool off
set heading on