Site icon Database Tutorials

Oracle Numeric/Math Functions

This article contains information about oracle numeric/math functions and their usage.

Numeric/Math Functions

Oracle has several functions for processing numerical data.

ABS Function in Oracle

Returns the absolute value of the numerical value.

ACOS Function in Oracle

Returns the arc cosine of the numerical value.

ASIN Function in Oracle

Returns the arc sine value of the numerical value.

ATAN Function in Oracle

Returns the arc tangent of the numerical value.

ATAN2 Function in Oracle

Returns the arc tangent of two numerical value.

AVG Function in Oracle

Calculates and returns the avarage value of an expression.

BITAND Function in Oracle

This function implements “With AND” operation to numerical values ​​given as parameters and returns an integer.

CEIL Function in Oracle

Rounds the numerical value to next bigger integer value.

COS Function in Oracle

Returns the cosine value of the numerical value.

COSH Function in Oracle

Returns the hyperbolic cosine value of the numerical value.

EXP Function in Oracle

Returns e raised to the nth power, where e = 2.71828183.

FLOOR Function in Oracle

Rounds the numerical value to next smaller integer value.

GREATEST Function in Oracle

Returns the largest value in expressions given as parameters.

LEAST Function in Oracle

Returns the smallest value in expressions given as parameters.

LN Function in Oracle

Returns the natural logarithm of the numerical value.

LOG Function in Oracle

Returns the logarithm of a base b.

MAX Function in Oracle

Returns the maximum value of an expression.

MIN Function in Oracle

Returns the minimum value of an expression.

MEDIAN Function in Oracle

Returns the median of an expression.

MOD Function in Oracle

Returns the remainder of a divided by b.

POWER Function in Oracle

Returns a raised to the bth power.

 ROUND Function in Oracle

The parameters of the function are as follows.

ROUND(number,decimal_places)

number                   ->  number will be rounded

decimal_places     -> This parameter is optinal. If you do not specify this parameter, functions removes ol decimal places from the number. If you set this parameter, it will round decimal places as much as this parameters value.

SIGN Function in Oracle

Returns the sign of the numerical value.

SIN Function in Oracle

Returns the sine of the numerical value.

SINH Function in Oracle

Returns the hyperbolic sine of the numerical value.

SQRT Function in Oracle

Returns the square root of the numerical value.

SUM Function in Oracle

Returns the summed value of the numerical value.

TAN Function in Oracle

Returns the tangent of the numerical value.

TANH Function in Oracle

Returns the hyperbolic tangent of the numerical value.

TRUNC Function in Oracle

This functions truncates the decimal places on a decimal value. If you specify second parameter which is optinal, it truncates the decimal places according to this parameter.

Examples:

Exit mobile version