oracle四舍五入、取整例子

将一个字段四舍五入取整：

update project_report

   set bt_budget_applay = round(bt_budget_applay, 0)

 where report_date = 02

   and report_year = '2016'

将一个字段四舍五入取4位小数：

update project_report

   set bt_budget_applay = round(bt_budget_applay, 4)

 where report_date = 02

   and report_year = '2016'