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!

Problem with ROUND & DIVIDE Function

MN RajanAug 20 2013 — edited Aug 20 2013

Hello All,

I am dividing 4000 by 3 and rounding the result to 7 decimal places.

SELECT ROUND((4000/3),7) FROM DUAL;

Above query is giveing the result as 1333.3333333.

When I multiply 1333.3333333 * 3, Its giving 3999.9999999 instead of 4000.

SELECT 1333.3333333 * 3 FROM DUAL;

I need 4000 when I do Multiply.

Appreciate your help.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2013

Added on Aug 20 2013

2 comments

1,084 views