Oracle Oracle Functions-numeric functions

First, the numerical function

1. MoD (m,n) to find 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]) rounding

If n has no value, the default is 0, which is equivalent to rounding.

If n >0, it is rounded to the N-bit after the decimal point.

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

3. Ceil (n) rounding

Ceil is the ceiling, the ceiling is on the top, so it's the whole thing, and we can remember that.

　　

The upper rounding is the big one, and the 12.34 is 12, so the Ceil (-12.34) value is-12.

4. Floor (n) Next rounding

Floor is the meaning of flooring, the floor is below, so is the next rounding.

　　

The next rounding is toward the small, 12.34 toward the small-13, so the floor (-12.34) value is-13.

5. Power (M,n) asks M's N-th

　　

6. Trunc (M[,n]) truncation function

n if not filled, the default is 0, which is equivalent to rounding

If n>0, truncates the right of the decimal point to n bits

If n<0, truncates the left n digits of the decimal point

　　

Oracle Oracle Functions-numeric functions