title: Oracle Save decimal in a column with number datatype
body: <p>I have a table where one of the column has datatype <strong>number(20)</strong>. In one of the cases I need to save a value which is decimal into the column but the column automatically converts it into a whole number. Below is a simple test table I created to test this scenario.</p>
  
  <pre><code>create table test_tbl
  (
    amt    number(20)
  )
  
  insert into test_tbl values (9.999)
  </code></pre>
  
  <p>The above inserts a value of 10 rather than 9.999. How can I save 9.999 exactly as it is?</p>
  
  <p>Thanks</p>