NUMBER FUNCTIONS

NUMBER FUNCTIONS

ROUND()

SQL> select round(345.678) from dual;

ROUND(345.678)
--------------
           346

SQL> select round(345.578) from dual;

ROUND(345.578)
--------------
           346

SQL> select round(345.478) from dual;

ROUND(345.478)
--------------
           345

SQL> select round(345.478,1) from dual;

ROUND(345.478,1)
----------------
           345.5

SQL> select round(345.478,2) from dual;

ROUND(345.478,2)
----------------
          345.48

SQL> select round(345.478,-2) from dual;

ROUND(345.478,-2)
-----------------
              300

SQL> select round(345.478,-3) from dual;

ROUND(345.478,-3)
-----------------
                0

SQL> select round(345.478,-1) from dual;

ROUND(345.478,-1)
-----------------
              3

TRUNC() 

SQL> select trunc(345.456) from dual;

TRUNC(345.456)
--------------
           345

SQL> select trunc(345.656) from dual;

TRUNC(345.656)
--------------
           345

SQL> select trunc(345.656,2) from dual;

TRUNC(345.656,2)
----------------
          345.65

SQL> select trunc(345.656,1) from dual;

TRUNC(345.656,1)
----------------
           345.6

SQL> select trunc(345.656,0) from dual;

TRUNC(345.656,0)
----------------
             345

SQL> select trunc(345.656,2) from dual;

TRUNC(345.656,2)
----------------
          345.65

MOD()

SQL> select mod(10,2) from dual;

 MOD(10,2)
----------
         0

SQL> select mod(10,3) from dual;

 MOD(10,3)
----------
         1

POWER()

SQL> select power (10,3) from dual;

POWER(10,3)
-----------
       1000

SQL> select power (5,3) from dual;

POWER(5,3)
----------
       125
 
CEIL()

SQL> SELECT CEIL(2.1) FROM DUAL;

CEIL (2.1)
----------
      3

SQL> SELECT CEIL(2.9) FROM DUAL;

CEIL (2.9)
----------
      3