PL/SQLNumber numeric Functions

Source: Internet
Author: User
Tags bitwise operators natural logarithm
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.

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.