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!

Always Round Up

ChoMan23Mar 5 2012 — edited Mar 5 2012

I am trying to find a way to always round up to the next whole number. For example if I have 2.08 I need it to return 3. If I try this SELECT ROUND(2.08) FROM DUAL; it rounds to 2. I am using Oracle 11g. Any help would be appreciated. Thank you.

This post has been answered by sb92075 on Mar 5 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2012

Added on Mar 5 2012

5 comments

25,711 views