This will rounds numbers to a given number of digits of precision.
Syntax: round (value, precision)
Ex:
SQL> select round(123.2345), round(123.2345,2), round(123.2354,2) from dual;
ROUND(123.2345) ROUND(123.2345,0) ROUND(123.2345,2)ROUND(123.2354,2)
--------------------- ------------------------ ----------------------- ---------------------
123 123 123.23 123.24
ROUND(123.2345) ROUND(123.2345,0) ROUND(123.2345,2)ROUND(123.2354,2)
--------------------- ------------------------ ----------------------- ---------------------
123 123 123.23 123.24
SQL> select round(123.2345,-1), round(123.2345,-2), round(123.2345,-3),round(123.2345,-4) from dual;
ROUND(123.2345,-1)ROUND(123.2345,-2)ROUND(123.2345,-3)ROUND(123.2345,-4)
------------------------ ------------------------- ------------------------ -------------------
120 100 0 0
SQL> select round(123,0), round(123,1), round(123,2) from dual;
ROUND(123,0) ROUND(123,1) ROUND(123,2)
----------------- ----------------- ----------------
123 123 123
SQL> select round(-123,0), round(-123,1), round(-123,2) from dual;
ROUND(-123,0) ROUND(-123,1) ROUND(-123,2)
------------------ ----------------- -------------------
-123 -123 -123
SQL> select round(123,-1), round(123,-2), round(123,-3), round(-123,-1), round(-123,- 2), round(-123,-3) from dual;
ROUND(123,-1) ROUND(123,-2) ROUND(123,-3) ROUND(-123,-1) ROUND(-123,-2)
ROUND(-123,-3)
-------------- ------------- ------------- -------------- -------------- --------------
120 100 0 -120 -100 0
SQL> select round(null,null), round(0,0), round(1,1), round(-1,-1), round(-2,-2) from dual;
ROUND(NULL,NULL) ROUND(0,0) ROUND(1,1) ROUND(-1,-1) ROUND(-2,-2)
----------------------- -------------- -------------- ---------------- ----------------
Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com
ReplyDelete