SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rounding to a Desired Number of Significant Figures

wferroOct 14 2013 — edited Oct 14 2013

I have a set of calculated results that I need to round to two significant figures. The rounding rules that I need to use are 5 and above rounds up and below 5 rounds down (I'm not taking into consideration whether or not the number before the 5 is odd or even). For example, I would need to round 0.04255 to 0.043 and 0.0255813953 to 0.026 etc. What is the best way to do this?

This post has been answered by Ramin Hashimzadeh on Oct 14 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 11 2013

Added on Oct 14 2013

4 comments

773 views