oracle ORA-01476:divisor is equal to zero
来源:互联网 发布:js href只能写在a中吗 编辑:程序博客网 时间:2024/06/04 14:00
在执行SQL语句时报ORA-01476:divisor is equal to zero
主要的原因是在SQL语句中除数为0。例如:select a/b from c;当b为0时执行SQL就会报ORA-01476:divisor isequal to zero
修改后:
select decode(b,0,0,a/b) from c;
这样就可以了。
有关于oracle 的decode的用法请看下一篇文章
- oracle ORA-01476:divisor is equal to zero
- ORA-01476: divisor is equal to zero解决方法
- Find pairs equal zero -- Paypal
- A Proof That P Is Not Equal To NP?
- why unsigned int 0xFFFFFFFF is equal to int -1?
- ORA-01034: ORACLE not available 、ora-00064:object is too large to allocate on this O/S
- [morals is a way to success]How to know a float number is equal to another
- linux oracle ORA-01221: data file 1 is not the same file to a background process
- reference to a zero-sized array is illegal解决办法
- This is it——Zero to Hero
- Oracle错误代码ORA-00000 to ORA-00832
- Row index must be greater than or equal to zero and less than the number of rows.
- Zero to the Zero Power
- 【from zero to zero】noip2017
- Oracle : ORA-28000: the account is locked
- 【ORACLE】ORA-28000 the account is locked-的解决办法;ORA-39001,ORA-39000,ORA-39143
- The answer is zero.
- Oracle: failed to parse tnsnames.ora file
- flex接收flashvars参数值
- ubuntu安装java环境
- oracle里的自动增长字段,可以用触…
- quartz的触发器CronTriggerBean配置
- decode函数用法
- oracle ORA-01476:divisor is equal to zero
- Spring3中aop的配置方法
- hibernate二级缓存
- Strut1和Spring的整合
- fmt标签的使用
- 亚马逊推荐系统神话般60%转化率的背后
- DispatchAction
- JXL 读取excel数据
- Tomcat Context配置