title: Varchar to decimal oracle 11g
body: <p>how to convert varchar to decimal without rounding off.Currently oracle is rounding it off to 5 decimal digits for eg if the varchar data is 1.00037388  then the result data after using the   ----<code>cast(EN_Cent as decimal(10,9))</code> cast to decimal function as 1.00037.Need to prevent this from happening</p>
  
  <p>thanks</p>
  
  <p>sri</p>