title: Decimal number, to_char, and Oracle
body: <p>I am trying to figure out a format spec of to_char() that would give me the following result.</p>
  
  <pre><code>to_char(0.1, '[FORMAT_SPEC]')
  </code></pre>
  
  <p>gives 0.1 and:</p>
  
  <pre><code>to_char(1, '[FORMAT_SPEC]')
  </code></pre>
  
  <p>gives 1.</p>
  
  <p>I've tried the following solutions:</p>
  
  <pre><code>to_char(0.1)
  </code></pre>
  
  <p>gives '.1'.</p>
  
  <pre><code>to_char(0.1, 'FM0.099')
  </code></pre>
  
  <p>gives 0.1, which is okay, however:</p>
  
  <pre><code>to_char(1, 'FM0.099')
  </code></pre>
  
  <p>gives 1.0, which is not okay.</p>
  
  <p>Do you have any suggestions?</p>