Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 77 of 121
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.
SELECT ROUND(15.193,1) "Round" FROM DUAL; Round ---------- 15.2
SELECT ROUND(15.193,-1) "Round" FROM DUAL; Round ---------- 20
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|