title: decimal data type in Oracle
body: <p>My database table contains one column of <code>varchar2(20,10)</code>, but since it is a total amount field I need currency data type.  (If I enter 1235.5 it should take it as 1235.50.)</p>
  
  <p>I tried changing to type <code>number(20,2)</code>, I am not able to do this with number(20,2) in Oracle 10g.</p>