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
oracle除法
最新推荐文章于 2023-01-31 10:10:36 发布
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