读书人

Oracledecode()处置被除数为0

发布时间: 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

读书人网 >其他数据库

热点推荐