Oracle built-in function (a) numeric function

Oracle built-in functions are divided into four main categories:

• numeric functions
• Character functions
• Date function
• Conversion functions

This analytical numerical function:

First, rounding round

Round (DOUBLE,M)

Double: we want to deal with the decimals.

M:

Default: In the case of not filling out the defaults to 0, that is, rounding;

M>0: Rounding the decimal point m;

M<0: Rounds the M-bit before the decimal point.

Example

Second, take the whole

Ceil: Rounding up

Floor: Rounding Down

Three, commonly used calculation

1, ABS: Take absolute value

2, MoD: Take the remainder (except modulo) any parameter is NULL returns NULL

3. Power: Power function

4, sqrt: Seek square root

The four or three-corner function is not analyzed at this stage.

Oracle built-in function (a) numeric function