How can I turn off the SQL>, i ONLY WANT TO GET THE RESULT,I did try
SET VERIFY OFF
SET HEADING 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