Oracle's Single-line functions: Numeric functions

Oracle_ Single Function _ number function

1.abs (x)

To get the absolute value of X

2.ceil (x)

Used to get the smallest integer greater than or equal to X

3.floor (x)

Used to get the largest integer less than or equal to X

4.mod (X,y)

The remainder that is used to calculate x divided by Y

5.power (X,y)

Used to compute the Y-power of X

6.round (X[,y])

Used to calculate the rounding result of X

Optional argument y: Describes rounding decimal numbers and rounding x at 0 decimal places if y is not specified

If Y is a negative number, the X is rounded to the |y| at the left of the decimal point

7.sign (x)

Symbol used to get X

If x is negative, returns-1, returns 1 if X is positive, and returns 0 if X is 0.

8.SQRT (x)

Used to compute the square root of X

9.trunc (X[,y])

Used to calculate the result of an X truncation

Optional argument y: Describes the fractional decimal truncation, and if Y is not specified, truncate x at 0 decimal places

If Y is a negative number, the X is truncated at the |y| bit to the left of the decimal point

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/