title: Spool to save file with pipe '|'
body: <p>I have the below query that saves the results to a csv file. How can I modify the query so the columns are separated by pipe '|' rather than comma? Also, when I open the csv file, the actual sql query is in the csv file as well, how I can exclude the query from the file?</p>
  
  <p>Currently using SQL Developer.</p>
  
  <p>Many Thanks.</p>
  
  <p>spool c:\temp\myoutputfile.csv</p>
  
  <p>select * from mytable;</p>
  
  <p>spool off;</p>