title: Oracle - how to remove white spaces?
body: <p>I am running this statement:</p>
  
  <pre><code>select trim(a),trim(b) from table x;
  </code></pre>
  
  <p>Even though I used the trim() statement, my output looks like this:</p>
  
  <pre><code>A                                                            B                              
  ___                                                          ____
  kunjramansingh                                               smartdude
  </code></pre>
  
  <p>The datatype of column 'a' and 'b' is varchar2(255).</p>
  
  <p>There is a gap between the data of two output.  I want to show the data without the whitespace - in a format like this:</p>
  
  <pre><code>A             B
  ___           ______ 
  kunjramansinghsmartdude
  </code></pre>
  
  <p>How can I do this?</p>