Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 100 of 166
round_number::=
round_number
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.
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-2001, Oracle Corporation. All Rights Reserved. |
|