title: Oracle how to export query to a text/csv file
body: <p>I was wondering how to go about exporting a query from PL/SQL to an text file or csv file. The query I have in mind exports a huge amount of data (about 1 gig). So I'd also like the data split across multiple files;</p>
  
  <p>out1.csv
  out2.csv
  out3.csv</p>
  
  <p>I'd like to be able to decide how many files to split it across.</p>
  
  <p>Anyone have any idea how to do this?</p>