title: Concatenate strings in Oracle SQL without a space in between?
body: <p>I am trying to concatenate strings in oracle.</p>
  
  <p>The following is my query:</p>
  
  <pre><code>insert into dummy values('c'||to_char(10000,'99999'));
  </code></pre>
  
  <p>The expected result is:</p>
  
  <pre><code>c10000
  </code></pre>
  
  <p>But the output I get is with a space in between 'c' and the value 10000:</p>
  
  <pre><code>c 10000 
  </code></pre>
  
  <p>How to concat without spaces?</p>