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.
Get Oracle PL/SQL Programming, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.