ORA-36376: (XSAGZERO) AGGREGATE attempted to divide by zero.
Set DIVIDEBYZERO to YES if you want NA to be returned as the
result of a division by zero.



ORA-36376: (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA..

Answer / guest

Cause: A calculation in the current AGGREGATE command
attempted to divide by zero as a result of an AVERAGE,
WAVERAGE, HAVERAGE or HWAVERAGE operation.

Action: Either fix the data, or set DIVIDEBYZERO to YES to
return NA instead of signalling an error.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01929: no privileges to GRANT

1 Answers  


NNL-00256: Server-generated requests now do not request forwarding

1 Answers  


RMAN-08590: channel string: datafile conversion complete, elapsed time: string

1 Answers  


ORA-29348: You must specify the datafiles to be plugged in

1 Answers  


ORA-16229: PDML child string string string for parent string string string cannot be skipped.

1 Answers  






ORA-01625: rollback segment 'string' does not belong to this instance

1 Answers  


ORA-25213: message with specified RELATIVE_MSGID has been dequeued

1 Answers  


ORA-13786: missing SQL text of statement object "string" for tuning task "string"

1 Answers  


DRG-52106: Oracle Text service results could not be committed

1 Answers  


ORA-09263: spini: error initializing process

1 Answers  


ORA-25234: NEXT_TRANSACTION navigation option invalid for queue table string.string

1 Answers  


ORA-14263: new subpartition name must differ from that of any other subpartition of the object

1 Answers  


Categories