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 issue

Vigneswar BattuJun 27 2014 — edited Jun 27 2014

Hi,

Any idea if this is right ?

select (1100.55*(1/30)), ROUND((1100.55*(1/30)),2)  from dual;

Shouldn't 36.685 be rounded 36.69 ?

Thanks,

Vignesh

This post has been answered by chris227 on Jun 27 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2014
Added on Jun 27 2014
26 comments
3,506 views