title: Stop spool printing the sql query used (Oracle)
body: <p>I have this running in SQLplus </p>
  
  <pre><code>set feedback off
  set pagesize 0
  spool TypeDrop.sql
  select distinct 'drop type '||object_name|| ';' from user_objects where object_type='TYPE';
  spool off
  </code></pre>
  
  <p>It prints out to TypeDrop.sql:</p>
  
  <pre><code>SQL&gt; select distinct 'drop type '||object_name||';' from user_objects where object_type='TYPE';
  drop type ADDRESS_OBJTYP; 
  drop type PERSON_OBJTYP;                                                                                                                                              
  SQL&gt; spool off
  </code></pre>
  
  <p>How do i get it to just output the <code>drop</code> statements? thanks</p>