title: Oracle SQL Developer: Exporting to XML without CDATA
body: <p>Recently started using Oracle SQL Developer. I have successfully run queries and exported results to XML (encoding='UTF-8').  e.g.</p>
  
  <pre><code>&lt;RESULTS&gt;
      &lt;ROW&gt;
          &lt;COLUMN NAME="ACCOUNTID"&gt;&lt;![CDATA[1]]&gt;&lt;/COLUMN&gt;
          &lt;COLUMN NAME="ADDRLINE1"&gt;&lt;![CDATA[XYZ company]]&gt;&lt;/COLUMN&gt;
          &lt;COLUMN NAME="ADDRLINE2"&gt;&lt;![CDATA[]]&gt;&lt;/COLUMN&gt;
          &lt;COLUMN NAME="ADDRLINE3"&gt;&lt;![CDATA[999 6th AVENUE]]&gt;&lt;/COLUMN&gt;
          &lt;COLUMN NAME="ADDRLINE4"&gt;&lt;![CDATA[NEW YORK]]&gt;&lt;/COLUMN&gt;
          &lt;COLUMN NAME="ADDRLINE5"&gt;&lt;![CDATA[NEW YORK, NY 10112]]&gt;&lt;/COLUMN&gt;
          &lt;COLUMN NAME="COUNTRY"&gt;&lt;![CDATA[USA]]&gt;&lt;/COLUMN&gt;
      &lt;/ROW&gt;
  </code></pre>
  
  <p>My question: is there a way to export without the CDATA defs?  i.e. it's "simple" data and what I want/need is:</p>
  
  <pre><code>&lt;Row&gt;
      &lt;X&gt;1&lt;/X&gt;
      &lt;ACCOUNTID&gt;1&lt;/ACCOUNTID&gt;
      &lt;ADDRLINE1&gt;XYZ company&lt;/ADDRLINE1&gt;
      &lt;ADDRLINE2/&gt;
      &lt;ADDRLINE3&gt;999 6th AVENUE &lt;/ADDRLINE3&gt;
      &lt;ADDRLINE4&gt;NEW YORK&lt;/ADDRLINE4&gt;
      &lt;ADDRLINE5&gt;NEW YORK, NY 10112&lt;/ADDRLINE5&gt;
      &lt;COUNTRY&gt;USA&lt;/COUNTRY&gt;
  &lt;/Row&gt;
  </code></pre>
  
  <p>Looked through preferences and could not find anything useful.  I saw a very old post stating that the resultant XML was generated via XSL but I couldn't find any XSL.</p>
  
  <p>Has anyone ever done this or have any ideas?</p>