ROUND

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