[Oracle] oracle functions-numeric functions, oracle function values

[Oracle] oracle functions-numeric functions, oracle function values

I. Numeric Functions

1. mod (m, n) Evaluate the remainder Function

NOTE: If m or n is null, null is returned. If n is 0, the value of m is returned.

Eg:

2. round (m [, n ])

If n is not passed, the default value is 0, which is equivalent to an integer.

If n> 0, it is rounded to n digits after the decimal point.

If n is less than 0, it is rounded to the first n digits of the decimal point.

3. ceil (n) rounded up

Ceil indicates the ceiling. The ceiling is above, so it is rounded up. We can remember it like this.

The rounded up value is greater, and the rounded up value is-12. Therefore, the ceil (-12.34) value is-12.

4. floor (n) rounded up

Floor is the meaning of the floor. The floor is below, so the floor is rounded down.

The rounded down value is a small value, and the rounded down value is-13. Therefore, the floor (-12.34) value is-13.

5. power (m, n) calculates the n power of m.

6. trunc (m [, n]) truncation Function

If n is not specified, the default value is 0, which is equivalent to an integer.

If n> 0, n digits to the right of the decimal point are truncated.

If n <0, n digits to the left of the decimal point are truncated.