Oracle SQL: the Essential Reference

ROUND

ROUND(n,m)

Rounds a value to a specified number of decimal places.

Parameters

n

Specifies a value to be rounded.

m

Specifies the number of decimal places to preserve in the result. This number must be an integer. A negative value for m results in the value being rounded to the left of the decimal point.

Example

SQL> SELECT ROUND(123.45), ROUND(123.45,1), ROUND(123.45,-1)
  2  FROM dual;

ROUND(123.45) ROUND(123.45,1) ROUND(123.45,-1)
------------- --------------- ----------------
          123           123.5              120