PL and SQL Number numeric type function
- 2020-05-30 21:13:39
- OfStack
The ABS(x) function, which returns the absolute value of a number.
ACOS(x), returns the arccosine of X. X ranges from 1 to -1, with input values from 0 to PI in radians.
ASIN(x) function, which returns the arcsine of X. X ranges from 1 to -1, with input values ranging from -PI /2 to PI/2 in radians.
ATAN(x) function, which returns the inverse tangent of X. The input values range from -PI /2 to PI/2 in radians.
BITAND(x,y) function, which returns the sum of X and Y. X and Y must be non-negative integers. Note that there is no BITOR function, but a bit operator for the RAW value is available in the UTL_RAW package.
The CEIL(x) function, which returns the smallest integer greater than or equal to X.
COS(x) function, which returns the cosine of x. x is in radians.
The COSH(x) function returns the hyperbolic cosine of X.
The EXP(x) function, similar to the power(x,y) function, returns E to the X power without specifying the cardinality. E = 2.71828183...
The FLOOR(x) function, which returns the maximum integer less than or equal to X.
LN(x) function, which returns the natural log of x. x has to be greater than 0.
LOG(x,y) function, which returns the logarithm of Y base X. The base must be a positive number that is not 0 and 1, Y is any positive number.
MOD(dividend, divisor) returns the dividend if the divisor is 0.
POWER(x,y) function, which returns the Y power of X. Neither base X nor index Y need to be positive integers, but if X is negative, Y must be integer.
ROUND(x[,y]) function, which returns the X value rounded to the Y bit to the right of the decimal point. Y defaults to 0, which rounds X to the nearest integer. If Y is a negative number, then rounded to the corresponding bit to the left of the decimal point, Y must be an integer.
SIGN(x), this function is used to return a positive or negative value of a number. If it is a positive value, it returns 1, and if it is a negative value, it returns -1.
If it's zero, it still returns zero, kind of like digitizing the analog.
SIN(x) function, returns the sine of X. x is in radians.
SINH(x) function, which returns the hyperbolic sine of x.
SQRT(x) function, which returns the square root of x. x cannot be negative.
TAN(x) function, which returns the tangent of x. x is in radians.
TANH(x) function, which returns the hyperbolic tangent of x.
TRUNC(x[,y]) intercepts the value function, Y is 0 by default, so X is truncated to an integer. If Y is negative, intercept to the right of the decimal point
WIDTH_BUCKET (x min, max num_buckets) can only be used SQL statement.
You can use WIDTH_BUCKET to create equal length segments based on the input parameters. The range MIN to MAX is divided into num_buckets sections, each of which has the same size. Return to section 1 where X is located. If X is less than MIN, 0 is returned, and if X is greater than or equal to MAX, num_buckets+ 1.MIN and MAX are returned
Neither can be NULL, num_buckets must be a positive integer. If X is NULL, NULL is returned.
ACOS(x), returns the arccosine of X. X ranges from 1 to -1, with input values from 0 to PI in radians.
ASIN(x) function, which returns the arcsine of X. X ranges from 1 to -1, with input values ranging from -PI /2 to PI/2 in radians.
ATAN(x) function, which returns the inverse tangent of X. The input values range from -PI /2 to PI/2 in radians.
BITAND(x,y) function, which returns the sum of X and Y. X and Y must be non-negative integers. Note that there is no BITOR function, but a bit operator for the RAW value is available in the UTL_RAW package.
The CEIL(x) function, which returns the smallest integer greater than or equal to X.
COS(x) function, which returns the cosine of x. x is in radians.
The COSH(x) function returns the hyperbolic cosine of X.
The EXP(x) function, similar to the power(x,y) function, returns E to the X power without specifying the cardinality. E = 2.71828183...
The FLOOR(x) function, which returns the maximum integer less than or equal to X.
LN(x) function, which returns the natural log of x. x has to be greater than 0.
LOG(x,y) function, which returns the logarithm of Y base X. The base must be a positive number that is not 0 and 1, Y is any positive number.
MOD(dividend, divisor) returns the dividend if the divisor is 0.
POWER(x,y) function, which returns the Y power of X. Neither base X nor index Y need to be positive integers, but if X is negative, Y must be integer.
ROUND(x[,y]) function, which returns the X value rounded to the Y bit to the right of the decimal point. Y defaults to 0, which rounds X to the nearest integer. If Y is a negative number, then rounded to the corresponding bit to the left of the decimal point, Y must be an integer.
SIGN(x), this function is used to return a positive or negative value of a number. If it is a positive value, it returns 1, and if it is a negative value, it returns -1.
If it's zero, it still returns zero, kind of like digitizing the analog.
SIN(x) function, returns the sine of X. x is in radians.
SINH(x) function, which returns the hyperbolic sine of x.
SQRT(x) function, which returns the square root of x. x cannot be negative.
TAN(x) function, which returns the tangent of x. x is in radians.
TANH(x) function, which returns the hyperbolic tangent of x.
TRUNC(x[,y]) intercepts the value function, Y is 0 by default, so X is truncated to an integer. If Y is negative, intercept to the right of the decimal point
WIDTH_BUCKET (x min, max num_buckets) can only be used SQL statement.
You can use WIDTH_BUCKET to create equal length segments based on the input parameters. The range MIN to MAX is divided into num_buckets sections, each of which has the same size. Return to section 1 where X is located. If X is less than MIN, 0 is returned, and if X is greater than or equal to MAX, num_buckets+ 1.MIN and MAX are returned
Neither can be NULL, num_buckets must be a positive integer. If X is NULL, NULL is returned.