Oracle functions-numeric Functions

Oracle functions-numeric Functions
1. Evaluate the remainder of the mod (m, n) function. Note: If m or n is null, null is returned. If n is 0, the return value of m is eg: 2. round (m [, n]) rounded. 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) is the ceiling. ceil is the ceiling. The ceiling is on the top, so the ceiling is rounded up. We can remember that the ceiling is large, -12.34 is greater than-12, so the ceil (-12.34) value is-12. 4. the floor (n) is the floor. The floor is under, so it is the floor. 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): Calculate the Npower of m 6. trunc (m [, n]) truncation function n if not specified, the default value is 0, which is equivalent to an integer. If n> 0, the 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.