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.
- 1 Answers
- 2655 Views
- I also Faced
- E-Mail Answers
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 |
NCR-04002: NCRR: Invalid interface descriptor
PCC-02340: structure contains a bit field
ORA-22287: invalid or modified directory occurred during string operation
LPX-00270: FTP error: ~s
ORA-02225: only EXECUTE and DEBUG privileges are valid for procedures
ORA-23399: generation of replication support for "string"."string" is not complete
NNC-00411: invalid default domain name "string"
ORA-12437: invalid policy option: string
ORA-19644: datafile string: incremental-start SCN is prior to resetlogs SCN string
ORA-30348: ADD and DROP cannot both be specified
ORA-16631: Operation requires shutdown of database/instance "string"
DRG-52110: error in writing extended knowledge base
Oracle Errors 
