ROUND(number) Function in Oracle

In Oracle, the ROUND(number) function returns a number rounded to a given number of decimal places.

By default, it rounds the number to zero decimal places, but you can provide an optional argument that specifies the number of decimal places to use.

Oracle also has a ROUND(date) syntax, which is used on dates. This article is solely about the ROUND(number) syntax, which is used on numbers.

Continue reading