>>>Previous>>>
Numeric Functions:
These functions operate on Numeric data hence is the name.
Note: Argument “num” in the following functions is any float-valued number.
ABS(num): Returns absolute value of the given number.(i.e. Always positive value)
SQL> SELECT ABS(10) FROM DUAL;
ABS(10)
----------
10
SQL> SELECT ABS(-10) FROM DUAL;
ABS(-10)
----------
10
CEIL(num):
It returns the smallest integer greater than the given number.
SQL> SELECT CEIL(123.456) FROM DUAL;
CEIL(123.456)
-------------
124
FLOOR(num):
It returns the largest integer smaller than the given value.
SQL> SELECT FLOOR(123.456) FROM DUAL;
FLOOR(123.456)
--------------
123
LN(num) :
It returns natural logarithm value of “num” .
SQL> SELECT LN(10) FROM DUAL;
LN(10)
----------
2.30258509
LOG(m, n):
It returns logarithm of “n” with base “m”.
SQL> SELECT LOG(100,10) FROM DUAL;
LOG(100,10)
-----------
.5
SQL> SELECT LOG(10,100) FROM DUAL;
LOG(10,100)
-----------
2
MOD(m, n) :
It returns remainder of “m” divided by “n”.
SQL> SELECT MOD(10,3) FROM DUAL;
MOD(10,3)
----------
1
POWER(m, n):
It returns value equal to “m” raised by “n”.
SQL> SELECT POWER(10,2) FROM DUAL;
POWER(10,2)
-----------
100
ROUND(m, n):
It rounds the given float-valued number “m” to the “n” places after the decimal
SQL> SELECT ROUND(1.23456) FROM DUAL;
ROUND(1.23456)
--------------
1
SQL> SELECT ROUND(1.23456,3) FROM DUAL;
ROUND(1.23456,3)
----------------
1.235
SQRT(m): It calculates square root value of number “m”
SQL> SELECT SQRT(9) FROM DUAL;
SQRT(9)
----------
3
TRUNC(m, n):
It truncates given float-valued number “m” to “n” places after the decimal.
SQL> SELECT TRUNC(1.23456) FROM DUAL;
TRUNC(1.23456)
--------------
1
SQL> SELECT TRUNC(1.23456,3) FROM DUAL;
TRUNC(1.23456,3)
----------------
1.234
GREATEST(expr1, expr2, …) :
It finds the greatest value among the given expressions.
SQL> SELECT GREATEST(4,7,3,5,9,2) FROM DUAL;
GREATEST(4,7,3,5,9,2)
---------------------
9
LEAST(expr1, expr2, …):
It finds the Lowest value among the given expressions.
SQL> SELECT LEAST(4,7,3,5,9,2) FROM DUAL;
LEAST(4,7,3,5,9,2)
------------------
2