SQL Numeric Functions

SQL Abs	Absolute value is the measure of the magnitude of value.
SQL Sign	Sign gives the sign of a value.
SQL Sqrt	This will give the square root of the given value.
SQL Mod	This will give the remainder.
SQL NVL	This will substitutes the specified value in the place of null values.
SQL NVL2	NVL2 Function we can pass three parameters if first parameter is not null it returns second parameter. if first parameter is null it return third parameter
SQL Power	Power is the ability to raise a value to a given exponent.
SQL Exp	This will raise e value to the give power.
SQL Ln	This is based on natural or base e logarithm.
SQL Log	This is based on 10 based logarithm.
SQL CEIL	This will produce a whole number that is greater than or equal to the specified value.
SQL Floor	This will produce a whole number that is less than or equal to the specified value.
SQL Round	This will rounds numbers to a given number of digits of precision.
SQL Trunc	This will truncates or chops off digits of precision from a number.
SQL Bitand	This will perform bitwise and operation.
SQL Greatest	This will give the greatest string.
SQL Least	This will give the least string.
SQL Coalesce	This will gives the first non-null string.