Oracledecode()处理被除数为0
如:
select (a/b*100) as percent from t
如果b为0会出现被除数为0
解决:
select decode(b,0,0,a/b*100) as percent from t
发布时间: 2012-07-15 20:11:36 作者: rapoo
Oracledecode()处理被除数为0
如:
select (a/b*100) as percent from t
如果b为0会出现被除数为0
解决:
select decode(b,0,0,a/b*100) as percent from t