PLSQLNumber numeric Functions
PL/SQL Number numeric Functions
ABS (x) function, which is used to return the absolute value of a number.
ACOS (x) function returns the arc cosine of X. X ranges from 1 to-1, and the input value ranges from 0 to pie, in radians.
The ASIN (x) function returns the arc sine of X. X ranges from 1 to-1. The input value ranges from-PI/2 to PI/2, in radians.
The ATAN (x) function returns the arc tangent of X. The input value ranges from-PI/2 to PI/2 in radians.
BITAND (x, y) function returns the result of X and Y. X and Y must be non-negative integers. Note that there is no BITOR function, but it is useful for bitwise operators of RAW values in the UTL_RAW package.
The CEIL (x) function returns the smallest integer greater than or equal to X.
COS (x) function returns the cosine of x. X is an angle in radians.
COSH (x) function returns the hyperbolic cosine of X.
EXP (x) function, similar to power (x, y) function, returns the X power of E without specifying the base number. E = 71828183...
The FLOOR (x) function returns the largest integer less than or equal to X.
LN (x) function returns the natural logarithm of x. X must be greater than 0.
The LOG (x, y) function returns the base Y logarithm of X. The base must be a positive number not 0 or 1, and Y must be any positive number.
MOD (divisor, divisor) evaluates the remainder function. If the divisor is 0, the devisor is returned.
The POWER (x, y) function returns the power y of X. Neither the bottom X nor the exponent Y must be a positive integer, but if X is a negative number, Y must be an integer.
The ROUND (x [, y]) function returns the X value rounded to the Y-digit to the right of the decimal point. Y is 0 by default, which rounds X to the nearest integer. If Y is a negative number, round it to the corresponding digit on the left of the decimal point. Y must be an integer.
SIGN (x) function. This function is used to return positive and negative values of a number. If it is a positive number, 1 is returned. If it is a negative number,-1 is returned,
If the value is 0, the return value is still 0, which is a bit similar to the meaning of digitalization of analog.
SIN (x) function returns the sine of X. X is an angle in radians.
The SINH (x) function returns the hyperbolic sine of x.
The SQRT (x) function returns the square root of x. x cannot be a negative number.
The TAN (x) function returns the tangent of x. X is an angle in radians.
The TANH (x) function returns the hyperbolic tangent of x.
TRUNC (x [, y]) truncates the value function. The default value of Y is 0, so that X is truncated into an integer. If Y is negative, it is truncated to the right of the decimal point.
WIDTH_BUCKET (x, min, max, num_buckets) can only be used in SQL statements.
You can use WIDTH_BUCKET to create an equal-length segment based on input parameters. The range of MIN to MAX is divided into num_buckets sections, each of which has the same size. Returns the section where X is located. If X is less than MIN, 0 is returned. If X is greater than or equal to MAX, num_buckets + 1. MIN and MAX are returned.
Cannot be NULL, and num_buckets must be a positive integer. If X is NULL, NULL is returned.
