title: Oracle Unicode Spooling
body: <p>How can I spool data from a table to a file which contains Unicode characters?</p>
  
  <p>I have a sql file which I execute from SQL*Plus screen and its content is:</p>
  
  <pre><code>SET ECHO OFF
  SET FEEDBACK OFF
  SET HEADING OFF
  SET PAGESIZE 0
  SPOOL STREET_POINT_THR.BQSV
  SELECT GEOX||'`'||GEOY||'`'||UNICODE_DESC||'`'||ASCII_DESC 
  FROM GEO.STREET_POINTS;
  SPOOL OFF
  </code></pre>