QSM-02143: SUM(expr) without COUNT(expr)



QSM-02143: SUM(expr) without COUNT(expr)..

Answer / guest

Cause: SUM(expr) occurs in the select list without a
corresponding COUNT(expr).

Action: Add COUNT(expr) to the select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00351: recover-to time invalid

1 Answers  


ORA-16770: physical standby database not in read-only state.

1 Answers  


ORA-13227: SDO_LEVEL values for the two index tables do not match

1 Answers  


ORA-09367: Windows 3.1 Two-Task driver unable to deallocate shared memory

1 Answers  


ORA-00031: session marked for kill

1 Answers  






ORA-31661: there are no metadata transform values of type VARCHAR2

1 Answers  


PLS-00639: NCHAR/NVARCHAR2 cannot be byte length semantics

1 Answers  


PCC-00016: Unable to open a cursor at line number in file string

1 Answers  


ORA-07390: sftopn: translate error, unable to translate file name.

1 Answers  


ORA-24281: invalid access past the maximum size of LOB parameter string

1 Answers  


NNO-00608: received corrupted message

1 Answers  


ORA-13770: Baseline "string" does not exist.

1 Answers  


Categories