Oracle Numeric Functions (JNNC Technologies) testing training institutes in visakhapatnam

                                                             http://jnnctechnologies.com/

Function	Description
ABS	Returns the absolute value of a number
ACOS	Returns the arc cosine of a number
ASIN	Returns the arc sine of a number
ATAN	Returns the arc tangent of a number
ATAN2	Returns the arc tangent of n and m
AVG	Returns the average value of an expression
BITAND	Returns an integer representing an AND operation on the bits of expr1 and expr2
CEIL	Returns the smallest integer value that is greater than or equal to a number
COS	Returns the cosine of a number
COSH	Returns the hyperbolic cosine of a number
COUNT	Returns the count of an expression
EXP	Returns e raised to the power of number
FLOOR	Returns the largest integer value that is equal to or less than a number
GREATEST	Returns the greatest value in a list of expressions
LEAST	Returns the smallest value in a list of expressions
LN	Returns the natural logarithm of a number
LOG	Returns the natural logarithm of a number to a specified base
MAX	Returns the maximum value of an expression
MEDIAN	Returns the median of an expression
MIN	Returns the minimum value of an expression
MOD	Returns the remainder of n divided by m
POWER	Returns m raised to the nth power
REGEXP_COUNT	Counts the number of times that a pattern occurs in a string
REMAINDER	Returns the remainder of m divided by n
ROUND	Returns a number rounded to a certain number of decimal places
ROWNUM	Returns a number that represents the order that a row is
SIGN	Returns a value indicating the sign of a number
SIN	Returns the sine of a number
SQRT	Returns the square root of a number
SUM	Returns the summed value of an expression
TAN	Returns the tangent of a number
TANH	Returns the hyperbolic tangent of n
TRUNC	Returns a number truncated to a certain number of decimal places