# Oracle Numeric/Math Functions

Oracle functions are built into Oracle and are available for use in various appropriate Oracle statements. You can also create your own function using PL/SQL.

Function Description
ABSReturns the absolute value of n.
ACOSReturns the arc cosine of n.
ASINReturns the arc sine of a number.
ATANReturns the arc tangent of a number.
ATAN2Returns the arc tangent of n and m.
AVGReturns the average value of an expression.
BITANDReturns an integer representing an AND operation on the bits of expr1 and expr2.
CEILReturns the smallest integer value that is greater than or equal to a number.
COSReturns the cosine of a number.
COSHReturns the hyperbolic cosine of a number.
COUNTReturns the count of an expression.
EXPReturns e raised to the nth power
FLOORReturns the largest integer value that is equal to or less than a number.
GREATESTReturns the greatest value in a list of expressions.
LEASTReturns the smallest value in a list of expressions.
LNReturns the natural logarithm of a number.
LOGReturns the logarithm of n base m.
MAXReturns the maximum value of an expression.
MEDIANReturns the median of an expression.
MINReturns the minimum value of an expression.
MODReturns the remainder of m divided by n.
POWERReturns m raised to the nth power.
REGEXP_COUNTCounts the number of times that a pattern occurs in a string.
REMAINDERReturns the remainder of m divided by n.
ROUND (numbers)Returns a number rounded to a certain number of decimal places.
ROWNUMReturns a number that represents the order that a row is selected by Oracle from a table or joined tables.
SIGNReturns a value indicating the sign of a number.
SINReturns the sine of n.
SINHReturns the hyperbolic sine of n.
SQRTReturns the square root of n.
SUMReturns the summed value of an expression.
TANReturns the tangent of n.
TANHReturns the hyperbolic tangent of n.
TRUNC (numbers)Returns a number truncated to a certain