222

oracle除法

select MOD(65,50) from dual     --取余
select  trunc( 65/33) from dual  -- 取整 trunc (1.9) = 1
select ceil(65/60) from dual          -- 取整 ceil(1.1) = 2

 

 

 

http://www.blogjava.net/fanyingjie/archive/2009/06/02/279627.html