title: Spool the data from a CLOB
body: <p>I have the result of several CLOB, (about 100 Clob). I want to to extract all the data in the CLOB in one one script. I searched for spool but for now I didnt how to use it .</p>
  
  <p>Example: select info from ex_employee where data &lt;15
  <br/></p>
  
  <blockquote>
    <p>INFO<br/>
    &lt; CLOB > <BR/>
    &lt; CLOB > <BR/>
    &lt; CLOB > <BR/>
    &lt; CLOB > <BR/>
    &lt; CLOB > <BR/></p>
  </blockquote>
  
  <p><br/>
  those CLOB contain informations how can I spool them into a script example.sql? <Br/></p>
  
  <p>My PROBLEM IS : How to export the CLOB data into .sql ?<br/></p>
  
  <p>I tried this way <br/>
  Spool on<br/>
  set heading off<br/>
  Spool c:\spooltext.txt<br/>
  select dbms_metadata.get_ddl('TABLE', table_name)<br/>
  from user_tables<br/>
  /<br/>
  Spool off </p>