I am so sorry guys, I don't know what's going on here, here what I have on my scripts:

SQL> set heading off
SQL> set verify off
SQL> set feedback off
SQL> set linesize 120
SQL> SET ECHO OFF
SQL> SPOOL C:\TEMP\oracle.SQL
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
SQL>


and below is my result:


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