The Oracle and PL/SQL ROUND function returns a number rounded to a certain number of decimal places.
ROUND( n, [numdec] )
If you omit numdec, then n is rounded to 0 places.
Example 1:
SELECT ROUND(45.1242,2) FROM DUAL;
returns:
45.12
Example 2:
SELECT ROUND(45.8242) FROM DUAL;
returns:
46
Example 3:
SELECT ROUND(-45.8242) FROM DUAL;
returns:
-46