What is The ROUND function ?

Started by beingchinmay, October 17, 2016, 08:28:50 AM

beingchinmay

The ROUND function returns the first argument rounded to the number of decimal places specified in the second argument. The specification for the ROUND function is:

FUNCTION ROUND (n NUMBER, [decimal_places NUMBER]) RETURN NUMBER;

The decimal_places argument is optional and defaults to 0, which means that n will be rounded to zero decimal places, a whole number. The value of decimal_places can be less than zero. A negative value for this argument directs ROUND to round digits to the left of the decimal point, rather than to the right. Here are some examples:

ROUND (153.46) ==> 153
ROUND (153.46, 1) ==> 153.5
ROUND (153, −1) ==> 150