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

NZE-29110: Invalid PKCS #12 bag type

1 Answers  


ORA-31078: error in SQL mapping information

1 Answers  


ORA-39068: invalid master table data in row with PROCESS_ORDER=string

1 Answers  


NNL-00015: type "string" has "string" syntax, which has no textual representation

1 Answers  


RMAN-06600: old RMAN configuration parameters:

1 Answers  






ORA-30486: invalid window aggregation group in the window specification

1 Answers  


PLS-00627: 'string' must be a strongly typed ref cursor

1 Answers  


NZE-28846: No private key

1 Answers  


ORA-09243: smsget: error attaching to SGA

1 Answers  


ORA-14268: subpartition 'string' of the partition resides in offlined tablespace

1 Answers  


ORA-36712: (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.

1 Answers  


ORA-24008: queue table string.string must be dropped first

1 Answers  


Categories