в 13:45, 26 мая 2010

2010-05-26T13:45:46Z

Admin: 1 версия

2010-05-26T10:08:50Z

1 версия

Новая страница

== Common numerical manipulation functions==

<OL><LI>near value functions.</LI><LI>null value functions.</LI><LI>log and exponential functions.</LI><LI>ordinary trigonometry functions.</LI><LI>hyperbolic trignometrical functions.</LI></OL>
14. 1. Introduction
14. 1. 1.
Common numerical manipulation functions
14. 1. 2.
<A href="/Tutorial/Oracle/0280__Numerical-Math-Functions/NumericFunctionsList.htm">Numeric Functions List</a>

== Numeric Functions List==

Numeric functions perform calculations.
Numeric functions accept an input number, which may come from a column in a table or from an expression that evaluates to a number.
A calculation is performed with this input and a number is returned.
An example of a numeric function is SQRT(), which returns the square root of the input number.
Function
Description
ABS(x)
Returns the absolute value of x.
ACOS(x)
Returns the arccosine of x.
ASIN(x)
Returns the arcsine of x.
ATAN(x)
Returns the arctangent of x.
ATAN2(x, y)
Returns the arctangent of x and y.
BITAND(x, y)
Returns the result of performing a bitwise AND on x and y.
COS(x)
Returns the cosine of x, where x is an angle in radians.
COSH(x)
Returns the hyperbolic cosine of x.
CEIL(x)
Returns the smallest integer greater than or equal to x.
EXP(x)
Returns the result of the number e raised to the power x, where e is approximately 2.71828183.
FLOOR(x)
Returns the largest integer less than or equal to x.
LOG(x, y)
Returns the logarithm, base x, of y.
LN(x)
Returns the natural logarithm of x.
LN(2.71828183) = 1
MOD(x, y)
Returns the remainder when x is divided by y.
POWER(x, y)
Returns the result of x raised to the power y.
ROUND(x [, y])
Returns the result of rounding x an optional y decimal places. If y is omitted, x is rounded to zero decimal places. If y is negative, x is rounded to the left of the decimal point.
SIGN(x)
Returns -1 if x is negative, 1 if x is positive, or 0 if x is zero.
SIN(x)
Returns the sine of x.
SINH(x)
Returns the hyperbolic sine of x.
SQRT(x)
Returns the square root of x.
TAN(x)
Returns the tangent of x.
TAN(0) = 0
TANH(x)
Returns the hyperbolic tangent of x.
TRUNC(x [, y])
Returns the result of truncating x an optional y decimal places. If y is omitted, x is truncated to zero decimal places. If y is negative, x is truncated to the left of the decimal point.

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL Tutorial/Numerical Math Functions/Introduction - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия