Math FunctionsThe math functions perform mathematical operations. AbsCalculates the absolute value of a numerical expression. Syntax: ABS (n_expression) where:
AcosCalculates the arc cosine of a numerical expression. Syntax: ACOS (n_expression) where:
AsinCalculates the arc sine of a numerical expression. Syntax: ASIN (n_expression) where:
AtanCalculates the arc tangent of a numerical expression. Syntax: ATAN (n_expression) where:
Atan2Calculates the arc tangent of y/x, where y is the first numerical expression and x is the second numerical expression. Syntax: ATAN2 (n_expression1, n_expression2) where:
CeilingRounds a noninteger numerical expression to the next highest integer. If the numerical expression evaluates to an integer, the Ceiling function returns that integer. Syntax: CEILING (n_expression) where:
CosCalculates the cosine of a numerical expression. Syntax: COS (n_expression) where:
CotCalculates the cotangent of a numerical expression. Syntax: COT (n_expression) where:
DegreesConverts an expression from radians to degrees. Syntax: DEGREES (n_expression) where:
ExpCalculates the value e to the power specified. Syntax: EXP (n_expression) where:
FloorRounds a noninteger numerical expression to the next lowest integer. If the numerical expression evaluates to an integer, the FLOOR function returns that integer. Syntax: FLOOR (n_expression) where:
LogCalculates the natural logarithm of an expression. Syntax: LOG (n_expression) where:
Log10Calculates the base 10 logarithm of an expression. Syntax: LOG10 (n_expression) where:
ModDivides the first numerical expression by the second numerical expression and returns the remainder portion of the quotient. Syntax: MOD (n_expression1, n_expression2) where:
PiReturns the constant value of pi (the circumference of a circle divided by the diameter of a circle). Syntax: PI() PowerTakes the first numerical expression and raises it to the power specified in the second numerical expression. Syntax: POWER(n_expression1, n_expression2) where:
RadiansConverts an expression from degrees to radians. Syntax: RADIANS (n_expression) where:
RandReturns a pseudo-random number between 0 and 1. Syntax: RAND() RandFromSeedReturns a pseudo-random number based on a seed value. For a given seed value, the same set of random numbers are generated. Syntax: RAND (n_expression) where:
RoundRounds a numerical expression to n digits of precision. Syntax: ROUND (n_expression, n) where:
Example: ROUND (12.358,2) Returns: 12.36 SignReturns a value of 1 if the numerical expression argument evaluates to a positive number, a value of -1 if the numerical expression argument evaluates to a negative number, and 0 if the numerical expression argument evaluates to zero. Syntax: SIGN (n_expression) where:
SinCalculates the sine of a numerical expression. Syntax: SIN (n_expression) where:
SqrtCalculates the square root of the numerical expression argument. The numerical expression has to evaluate to a nonnegative number. Syntax: SQRT (n_expression) where:
TanCalculates the tangent of a numerical expression. Syntax: TAN (n_expression) where:
TruncateTruncates a decimal number to return a specified number of decimal places. Syntax: TRUNCATE (n_expression, n) where:
Example: TRUNCATE (12.358,2) Returns: 12.35 |
Published 6/21/2021 | Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices. |