title: Decimal point is removed before update to character variable
body: <p>I have data in the below format and I want to update a destination table column of type <code>varchar2</code> with below values. But the problem is it updates as <code>.462</code> instead of <code>0.462</code> by using trim with leading <code>'0'</code>.</p>
  
  <pre><code>source              destination column
  -----------------   ------------------
  0000004.304300000   4.3043
  0000005.504500000   5.5045
  0000141.400000000   141.4
  0000138.900000000   138.9
  0000000.462000000   0.462
  0000000.000297000   0.000297
  </code></pre>