title: SQL keep two decimal places for integers after converting cent into dollar
body: <p>I am trying convert number values stored in the database as cents into dollar and keep 2 decimal places.</p>
  
  <p>The following code will work only if v_cent/100.00 is NOT integer</p>
  
  <pre><code>  SELECT CAST(ROUND(v_cent/100.00, 2) AS NUMERIC(8,2)) FROM DUAL;
  </code></pre>
  
  <p>If v_cent = 20000 then the result is 200.</p>
  
  <p>How could I reserve 2 decimal places even if the result is integer?</p>