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-32020: SID=* clause needed to modify this parameter

1 Answers  


RMAN-20201: datafile not found in the recovery catalog

1 Answers  


display details of employee's who are seniour to there own manager ? ( In a Emp Table )

2 Answers  


NCR-03012: NCRO: Invalid session mode

1 Answers  


SQL*Loader-00286: ROWS parameter is not supported when loading an IOT.

1 Answers  






ORA-25275: Test support for buffered queues

1 Answers  


TNS-12582: TNS:invalid operation

1 Answers  


PCC-00079: ANSI requires colon on label in WHENEVER statement

1 Answers  


SQL*Loader-00952: Error calling once/data file initialization

1 Answers  


ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

1 Answers   CGI,


ORA-02070: database stringstring does not support string in this context

1 Answers  


TNS-01007: quit | exit : exit LSNRCTL

1 Answers  


Categories