title: Building SQL query in XML with a CDATA select
body: <p>I have a very silly problem using an xml based tool to extract data from an oracle database;</p>
  
  <p>The datasource contains records with only one double quote, which is not handled in the code of the tool, and makes it crash. I can't change the source code of the tool, and I can't change the data source.</p>
  
  <p>Does anyone have a suggestion of how I could build up a query that would output something (unique and recognizable) where the data source contains double quotes? Keep in mind please I have to build the query as one xml string.</p>
  
  <p>So far I've tried using cdata, like this;</p>
  
  <pre><code>SQLSelect="select '&lt;![CDATA['||column_name||']]&gt;' from table_name"
  </code></pre>
  
  <p>The SQL select itself works fine in oracle, but it breaks my XML. Any help would be appreciated here.</p>