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 a number to a desired multiple

31331Dec 3 2004 — edited Dec 3 2004

Hi,

I will really appreciate if someone will give me some input on how to achieve a mround functionality in Oracle.

Basically if I have a number may be say 8706 and I want to round it to a multiple of 250 like in excel

mround(8706,250) you get 8750. How do I achieve this in Oracle. This is urgent. I will appreciate any kind of input.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2004

Added on Dec 3 2004

5 comments

1,173 views