Oracle function to round up

SQL function ROUND will round number with respect to the next digit.

Basically ROUND(15.68)=16 and

we have TRUNC to round downwards


Then how to round up wards?
This is very commonly needed function but a many of us are not aware of.. I used to add one and truncate to get the result. I found a function to round up very recently.

Function used  is  CEIL


Thank you..

No comments:

Post a Comment