–查小数位的精度大于2位的数据
select JE from XSB where decode(instr(JE,‘.’),0,0,nvl(to_number(substr(JE,instr(JE,‘.’)+3)),0))>0
SQL 查小数位的精度大于2位的数据
最新推荐文章于 2024-07-08 17:54:51 发布
–查小数位的精度大于2位的数据
select JE from XSB where decode(instr(JE,‘.’),0,0,nvl(to_number(substr(JE,instr(JE,‘.’)+3)),0))>0