Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 103 of 177
round_number::=
ROUND
returns number
rounded to integer
places right of the decimal point. If integer
is omitted, then number
is rounded to 0 places. integer
can be negative to round off digits left of the decimal point. integer
must be an integer.
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
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|