round Demo : ROUND « Numeric Math Functions « Oracle PL / SQL

1. Oracle PL / SQL
2. Numeric Math Functions
3. ROUND

round Demo

  
SQL>
SQL> SELECT ROUND(1234.5678, 4) FROM DUAL;

ROUND(1234.5678,4)
------------------
         1234.5678

SQL> SELECT ROUND(1234.5678, 3) FROM DUAL;

ROUND(1234.5678,3)
------------------
          1234.568

SQL> SELECT ROUND(1234.5678, 2) FROM DUAL;

ROUND(1234.5678,2)
------------------
           1234.57

SQL> SELECT ROUND(1234.5678, 1) FROM DUAL;

ROUND(1234.5678,1)
------------------
            1234.6

SQL> SELECT ROUND(1234.5678, 0) FROM DUAL;

ROUND(1234.5678,0)
------------------
              1235

SQL> SELECT ROUND(1234.5678, -1) FROM DUAL;

ROUND(1234.5678,-1)
-------------------
               1230

SQL> SELECT ROUND(1234.5678, -2) FROM DUAL;

ROUND(1234.5678,-2)
-------------------
               1200

SQL> SELECT ROUND(1234.5678, -3) FROM DUAL;

ROUND(1234.5678,-3)
-------------------
               1000

SQL>

   
  

Related examples in the same category