Oracle Error ORA-35280: (SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 …] [USING aggmap-name] [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 …]] [FUNCDATA] [FORCEORDER] [PARALLEL #] [{FROM|FROMVAR} fromname [, fromname2 …]]

Oracle Error Message

ORA-35280: (SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 …] [USING aggmap-name] [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 …]] [FUNCDATA] [FORCEORDER] [PARALLEL #] [{FROM|FROMVAR} fromname [, fromname2 …]]

Reason for the Error

The user used incorrect syntax for the AGGREGATE command.

Solution

Correct the calling syntax.