Numeric Functions

ABS:-        It returns the absolute value of give number
Syn:-         ABS(negative value)
Ex:-           select abs(-32) from dual;

POWER:-                        It returns M raised to  N th  times
Syn:-         POWER(m,n);
Ex:-           select power(5,4) from dual;

ROUND:- It returns M rounded to N places
Syn:-         ROUND(m,n);
Ex:-           select round(34.564,2) from dual;
                  Select round(34.564,1) from dual;
SQRT:-     It returns squreroot of give value
Syn:-         SQRT(value)
Ex:-           select sqrt(25) from dual;

TRUNC:- It is used to truncate the decimal number
Syn:-         TRUNC(valuewith decimals,no of decimals);
Ex:-           select trunc(10.54,1) from dual;
CEIL:-      It is used to ceil the given float value
Syn:-         CEIL(float value)
Ex:-           select ceil(32.65) from dual;
FLOOR:- It is used to round the float value to nearest int value
Syn:-         FLOOR(decimal value)
Ex:-           select floor(34.234) from dual;

MOD:-      It is used to find the mod(remainder) value for the given expression
Syn:-         MOD(m,n)
Ex:-           select mod(23,10) from dual;
COS:-       It is used to find the cos value.
Syn:-         COS(val)
Ex:-           select cos(10) from dual;
COSH:-    It is used to find the cosh value.
Syn:-         COSH(val);
Ex:-           select cosh(34) from dual;
EXP:-       It is used to find exponent value.
Syn:-         EXP(val)
Ex:-           select exp(20) from dual;

For
Online Classes

Contact Us: +919885348743