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
- 2670 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 |
ORA-02218: invalid INITIAL storage option value
ORA-01946: DEFAULT TABLESPACE already specified
ORA-32151: Environment not specified
ORA-21706: duration does not exist or is invalid
ORA-12922: concurrent ALTER DATABASE [NO] FORCE LOGGING command is running
ORA-12467: minimum label can contain a level only
TNS-04084: WARNING: Non-reloadable parameters have retained their values.
ORA-31084: error while creating table "string"."string" for element "string"
TNS-04017: Please wait. Shutdown in progress.
ORA-19720: Error occurred when converting an OCI number into an SCN
ORA-13829: SQL profile named string already exists
ORA-29863: warning in the execution of ODCIINDEXCREATE routine
Oracle Errors 
