oracle round函数的使用方法 .

来源：互联网发布：刷年费会员软件编辑：程序博客网时间：2024/06/05 00:07

round(input_value,decimal_places_of_precision),例如：    SQL>   select   round(1234.5678,4)   from   dual;       ROUND(1234.5678,4)    ------------------                      1234.5678       SQL>   select   round(1234.5678,3)   from   dual;       ROUND(1234.5678,3)    ------------------                        1234.568       SQL>   select   round(1234.5678,2)   from   dual;       ROUND(1234.5678,2)    ------------------                          1234.57       SQL>   select   round(1234.5678,1)   from   dual;       ROUND(1234.5678,1)    ------------------                            1234.6       SQL>   select   round(1234.5678,0)   from   dual;       ROUND(1234.5678,0)    ------------------                                1235       SQL>   select   round(1234.5678,-1)   from   dual;       ROUND(1234.5678,-1)    -------------------                                  1230       SQL>   select   round(1234.5678,-2)   from   dual;       ROUND(1234.5678,-2)    -------------------                                  1200       SQL>   select   round(1234.5678,-3)   from   dual;       ROUND(1234.5678,-3)    -------------------                                  1000