title: How to reduce scale value of a column
body: <p>I have an requirement to reduce the column value to <code>number(5)</code> from <code>number(6)</code>. For this i do not want to alter the column and instead just wanted to update the data using SQL query. </p>
  
  <p>Example:</p>
  
  <pre><code>From      to
  123456    12345
  135790    13579
  </code></pre>
  
  <p>i.e. i just wanted to remove the last digit.</p>