title: How to expand decimal places of a number to a minimum in Oracle PLSQL?
body: <p>I cant figure out how to select the following:</p>
  
  <pre><code>123        -&gt; 123.00000
  123.12     -&gt; 123.12000
  123.123456 -&gt; 123.123456
  </code></pre>
  
  <p>I would like to expand the number of decimal places to for example 5 decimal places (minimum)
  If there are no decimal places at all there should be 5 zeros.
  It is fine if there are more then 5 decimal places.</p>
  
  <pre><code>SELECT ROUND(123,5) FROM DUAL;
  </code></pre>
  
  <p>will result: 123
  instead of 123.00000</p>
  
  <p>The number has a default precision.</p>
  
  <p>Is this possible or should I convert it to a varchar with the <a href="http://ss64.com/ora/syntax-numfmt.html" rel="nofollow">oracle number formats</a>?</p>
  
  <p>I am using Oracle 10g with plsql.</p>