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 to nearest .5

colesgaOct 20 2008 — edited Jan 5 2010

Hi

I have a column which holds the byte size of the data row. I would like to round this to the nearest .5

example

1.23453 = 1
1.345 = 1.5
1.6523 = 1.5
1.7893 = 2

Does anyone know how to do this easily without have to cerate an user defined function.

Cheers
Gary

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2010

Added on Oct 20 2008

7 comments

4,265 views