I did set those options before I post here but seem it's not working and I don't know what I am missing here:

below is the result on my output:

SQL> set heading off
SQL> set verify off
SQL> SELECT 'ALTER TABLE ' ||CODE ||' THIS IS ONLY A TEST;' FROM AGENCY;

ALTER TABLE CSFM THIS IS ONLY A TEST;
ALTER TABLE TRRC THIS IS ONLY A TEST;

SQL> spool off



below is what I have on my script:


spool c:\temp\oracle.sql
set heading off
set verify off
set linesize 120
SELECT 'ALTER TABLE ' ||CODE ||' THIS IS ONLY A TEST;' FROM AGENCY;

spool off