title: divide and insert with precision oracle
body: <p>I need insert one record in table with precision in query. For example:</p>
  
  <pre><code>insert into spend_amount (record_no,purchase_amount) 
  values ('1',(to_number(100.99/2))); 
  </code></pre>
  
  <p>I have a purchase_amount column as VARCHAR2. So that when executing this query it inserted as <code>50.495</code>. But I need to insert two places of precision only. Expected result should be <code>50.49</code> or should round up as <code>50.50</code>. How to achieve this?</p>