Skip to Main Content

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!

Round function

780828Oct 28 2010 — edited Oct 29 2010
I have a requirement to round of numbers which have higher precision to reduce it to 2 decimal places. I am not able to use the round function directly since it doesn't work as expected. Any help in this regard is appreciated.


Example:

A weight of a part is 0.00375 and height of a Part is 0.00025.

Both weight and height should be rounded up to: 0.01

In addition, if the Parts value has 3 or 4 decimal places, the value should be rounded up to 2 decimal places.

Example: values of 0.003 or 0.0037 should be rounded up to 0.01
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2010
Added on Oct 28 2010
3 comments
411 views