Oracle PL/SQL Programming, Third Edition

Name

ROUND

Synopsis

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

For a comparison of ROUND with several other numeric functions, see Table 9-7 and Figure 9-5 earlier in Section 9.3.1.