title: unable to add or concatenate ' for the column value
body: <p>I am trying to fetch account details in csv format.</p>
  <p>My SQL Query is as follows:</p>
  <pre><code>select TRIM(ACC_NO), ACC_NAME, APPROVED_LIMIT, OUTSTANDING_AMT
  </code></pre>
  <p>The output is as follows:</p>
  <blockquote>
  <p>8.00013E+11, HSBC, 500000, 10000</p>
  </blockquote>
  <p>In csv, when I add 'before Acc_No, I can see the whole Account no like following:</p>
  <blockquote>
  <p>'8.00013E+11 --&gt; 800013443902</p>
  </blockquote>
  <p>But i am not able to concatenate the same in SQL Query but it's not working(Oracle). Could you please assist</p>
  <pre><code>select '''||TRIM(ACC_NO), ACC_NAME, APPROVED_LIMIT, OUTSTANDING_AMT
  </code></pre>
  <p>if i add anything else like , the output comes properly</p>
  <pre><code>select '\'||TRIM(ACC_NO), ACC_NAME, APPROVED_LIMIT, OUTSTANDING_AMT
  </code></pre>
  <blockquote>
  <p>\800013443902, HSBC, 500000, 10000</p>
  </blockquote>