Summary of Oracle's fractional method for intercepting fixed digits

Trunc,to_char,round,cast

1.trunc intercept the number, the decimal place directly, the whole digit takes 0. Do not make rounding

The second argument is the number of bits to intercept, and if it is not an integer, only the integer digits.

2.to_char (), which turns the number into a character and intercepts the number of digits, and rounds it. For the case of digital operation in this article, the first parameter of To_char can be float,numberic,int,

A second parameter template that describes what form to convert to.

Note D2, because the whole number of ' 9 ' is not enough, selected is ' # # '.

There are more ways to use the To_char function to convert numbers than to refer to the API.

3.round look at the name is the function of the approximate calculation of the number of the trunc, the same usage as the one, but it will be rounded

4.cast to number of specified digits

Summary of Oracle's fractional method for intercepting fixed digits