Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

DRG-10501: invalid stopword: string

1 Answers  


ORA-12682: Login failed: the SecurID card is in next PRN mode

1 Answers  


ORA-09300: osncon: unable to connect, DPMI not available

1 Answers  


ORA-31663: metadata remap name can not be defaulted

1 Answers  


RMAN-20272: no parent backup found for the incremental backup

1 Answers  






ORA-12523: TNS:listener could not find instance appropriate for the client connection

1 Answers  


ORA-29843: indextype should support atleast one operator

1 Answers  


TNS-00012: INTCTL: error while processing Connection Manager request

1 Answers  


NNL-00218: Ignoring spurious trailing text "string"

1 Answers  


ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

1 Answers  


ORA-06122: NETTCP: setup failure

1 Answers  


ORA-24292: no more tables permitted in this sorted hash cluster

1 Answers  






Categories