ABS (x) function, which is used to return the absolute value of a number.
ACOS (x) function that returns the inverse cosine of x. x ranges from 1 to 1, input values from 0 to pie, in radians.
ASIN (x) function that returns the inverse string value of x. x ranges from 1 to 1, input values from-PI/2 to PI/2, in radians.
Atan (x) function that returns the tangent value of x. Enter values from-PI/2 to PI/2, in radians.
Bitand (x,y) function that returns the result of X and Y. X and y must be non-negative integers. Note that there is no bitor function, but there are bitwise operators for raw values in the Utl_raw package.
Ceil (x) function that returns the smallest integer greater than or equal to X.
cos (x) function, which returns the cosine of x. X is the angle expressed in radians.
COSH (x) function that returns the hyperbolic cosine of x.
The EXP (x) function, similar to the Power (x,y) function, returns the x exponentiation of E without specifying the cardinality. e=2.71828183 ...
FLOOR (x) function that returns the largest integer less than or equal to X.
The LN (x) function, which returns the natural logarithm of x. x must be greater than 0.
Log (x,y) function that returns the logarithm of x as the base Y. The bottom must be a positive number that is not 0 and 1, and Y is any positive number.
MOD (dividend, divisor) remainder function, if the divisor is 0, then return dividend.
The Power (x,y) function, which returns the Y-exponentiation of X. Both the bottom x and the exponential y do not have to be positive integers, but if x is a negative number, y must be an integer.
ROUND (X[,y]) function that returns the X value rounded to the right y bit of the decimal point. The Y defaults to 0, which rounds x to the nearest integer. If Y is a negative number, then round to the appropriate bit to the left of the decimal point, y must be an integer.
SIGN (x) function, which returns a positive negative value for a number, returns 1 if one is positive, and returns 1 if it is negative.
If it is 0, it still returns 0, a bit like the meaning of digitizing analog.
Sin (x) function that returns the sine of x. X is the angle expressed in radians.
SINH (x) function that returns the hyperbolic sine of x.
SQRT (x) function that returns the square root of x and x cannot be negative.
The TAN (x) function, which returns the tangent of x. X is the angle expressed in radians.
TANH (x) function that returns the hyperbolic tangent of X.
TRUNC (X[,y]) intercepts the value function, and the Y defaults to 0, so that X is truncated to an integer. If Y is a negative number, intercept to the appropriate position to the left 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 the input parameters. The range 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, it returns 0, and if X is greater than or equal to Max, it returns num_buckets+1.min and Max
Cannot be null,num_buckets must be a positive integer. If x is null, NULL is returned.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
