title: Numeric overflow in plsql ORA-01426
body: <p>I have to calculate this </p>
  
  <pre><code>select power((1+(100000/365)),365)-1 from dual
  </code></pre>
  
  <p>but always gets numeric overflow no matter what i have changed.
  i tried with <code>pls_integer, cast,</code> to round the result.
  Please help me </p>