title: Oracle SQL Developer unable to export CLOB data
body: <p>I have a CLOB field in the query result of the query that I am running on SQL Developer. Now, the problem is that on the older version of SQL Developer, when I export the query result as insert statement, it provides me the CLOB data as expected however on the latest version it doesn't export CLOB fields, just to be sure of the behavior, I tried the same with other tables having CLOB fields and it is the same.</p>
  
  <p><a href="https://i.stack.imgur.com/hMroM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hMroM.png" alt="enter image description here"></a></p>
  
  <p><strong>Export Output</strong>                </p>
  
  <p><a href="https://i.stack.imgur.com/Z4JLq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Z4JLq.png" alt="enter image description here"></a></p>
  
  <p><strong>SQL Versions</strong></p>
  
  <p>With which it worked: Version 4.0.3.16<br>
  Where it is not working: Version 4.2.0.17.089</p>
  
  <p>Based on my understanding it is the settings that is causing the problem which I cannot seem to find anywhere. I have checked everything inside the <code>Tools &gt; Preferences</code> but there is no difference between the two versions and there is no specific setting for CLOB fields either.</p>