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除法
最新推荐文章于 2024-05-09 20:50:07 发布
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