Oracle numeric operations

Oracle numeric operations use oracle SQL to perform the following operations on numbers: rounded up, rounded down, N decimal places retained, rounded down, and number formatted (rounded down ): select floor (5.534) from dual; select trunc (5.534) from dual; both of the preceding operations can round down the number 5.534, and the result is 5. if you want to rounded up and get the result 6, use ceilselect ceil (5.534) from dual; Rounding: SELECT round (5.534) FROM dual; SELECT round (5.534, 0) FROM dual; SELECT round (5.534, 1) FROM dual; SELECT round (5.534, 2) FROM dual; the results are 6, 6, 5.5, respectively, 5.53 retain N decimal places (not rounded): select trunc (5.534, 0) From dual; select trunc (5.534, 1) from dual; select trunc (5.534, 2) from dual; results are 5, 5.5, 5.53, if the number of digits is 0, the result is an integer. Number formatting: select to_char (12345.123, '123. 9999 ') from dual; the result is 12345.123 select to_char (12345.123, '2017. 9900 ') from dual; the third and fourth digits after the decimal point are less than 0, and the result is 12345.1230 select to_char (0.123, '192. 9900 ') from dual; select to_char (0.123, '2017. 9900 ') from dual; the results are. 123, 0.123