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

user626688Oct 15 2010 — edited Oct 15 2010

Hi guys,

Is there any fuction in oracle that can round a decimal to its nearest quarter. eg.

3.13 will be 3.25
4.65 will be 4.75
4.60 will be 4.5
2.37 will be 2.25

Appreciate a help

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2010

Added on Oct 15 2010

2 comments

472 views