Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Numerical Math Functions

 

ROUND(345 678,2) ROUND(345 678,-1) ROUND(345 678,-2)

SQL> SQL> select round(345.678,2)   2  ,      round(345.678,-1)   3  ,      round(345.678,-2)   4  from   dual; ROUND(345.678,2) ROUND(345.678,-1) ROUND(345.678,-2) ---------------- ----------------- -----------------           345.68               350               300 SQL>