Oracle Error ORA-35282: (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname [USING aggmap-name] [COUNTVAR intvar-name] [FORCECALC] [FORCEORDER] [{FROM|FROMVAR} fromname [, fromname2 …]])

Oracle Error Message

ORA-35282: (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname [USING aggmap-name] [COUNTVAR intvar-name] [FORCECALC] [FORCEORDER] [{FROM|FROMVAR} fromname [, fromname2 …]])

Reason for the Error

The user used incorrect syntax for the AGGREGATE function.

Solution

Correct the calling syntax.