title: Adding decimal point and zeroes in Oracle
body: <p>Is there a way to specify that a <code>double</code> datatype will always have 2 points after the decimal point like currency usually has (oracle db) ?</p>
  
  <p>that is:</p>
  
  <pre><code>100 will be converted to 100.00
  101.1 will be converted to 101.10
  </code></pre>
  
  <p>Tried casting it and setting precision-scale but no luck with that it doesnt add default decimal point and zeroes</p>
  
  <pre><code>SELECT CAST((600.2) AS NUMERIC(28,2)) FROM DUAL;
  </code></pre>
  
  <p>Gives me <code>600.2</code></p>