ROUND (Number Function)

Syntax

Purpose

ROUND returns n rounded to m places right of the decimal point. If m is omitted, n is rounded to 0 places. m can be negative to round off digits left of the decimal point. m must be an integer.

Example 1

SELECT ROUND(15.193,1) "Round" FROM DUAL;

     Round
----------
      15.2

Example 2

SELECT ROUND(15.193,-1) "Round" FROM DUAL;

     Round
----------
        20