title: Export and insert CLOB data containing SQL statements with SQL Developer
body: <p>I have a table with a <code>CLOB</code> column containing SQL code. Now I want to transfer the content from the developer database into the productive one. I use the following script to export the content of the dev table:</p>
  
  <pre><code>set long 100000
  set lines 1000
  spool d:\export.sql
  select /*insert*/* from myTable;
  spool off
  </code></pre>
  
  <p>However, the import into the prod table is not working due to <code>'</code> characters in the SQL code. A generated insert statement looks like this:</p>
  
  <pre><code>insert into myTable (id, name, sql) 
  values (1, 'John', 'select * /* this is a hint */ 
                      from table1 
                      where attr1 = 'hi,you' and attr2 = 'me, too')
  </code></pre>
  
  <p>How can I insert this <code>CLOB</code>, or how do I export it in a better way?</p>