重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-36376: (XSAGZERO) AGGREGATE attempted to divide by zero. [打印本页]

作者: michaeljet 时间: 2016-9-2 17:33
标题: ORA-36376: (XSAGZERO) AGGREGATE attempted to divide by zero.

ORA-36376: (XSAGZERO) AGGREGATE attempted todivide by zero. Set

DIVIDEBYZERO to YES if you want NA to bereturned as the result of a

division by zero.

Cause: A calculation in the currentAGGREGATE command attempted to divide

by zero as a result of an AVERAGE, WAVERAGE, HAVERAGE orHWAVERAGE

operation.

Action: Either fix the data, or setDIVIDEBYZERO to YES to return NA instead of

signaling an error.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)