title: Oracle Sql concatenating a string with a number value trims leading zero for numbers less than 1
body: <p>I would like to concatenate two values and have something like </p>
  
  <pre><code>SELECT col1||col2 FROM tab1;
  </code></pre>
  
  <p>where col1 holds a string and col2 a number which works well as long as the value of col2 is greater than one. For values less than one the leading zero is trimed.
  For example:</p>
  
  <pre><code>Select 'A ' || 1.1 from dual; 
  </code></pre>
  
  <p>returns <code>A 1,1</code> but</p>
  
  <pre><code>Select 'A ' || 0.1 from dual; 
  </code></pre>
  
  <p>returns <code>A ,1</code>.
  How do i keep the leading zero and get for above example <code>A  0,10</code>?      </p>