ROUND (number)

Syntax

round_number::=

Text description of round_number

Purpose

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

Examples

The following example rounds a number to one decimal point:

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

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

The following example rounds a number one digit to the left of the decimal point:

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

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