PLS-00118: Duplicate group-by clause in table expression



PLS-00118: Duplicate group-by clause in table expression..

Answer / guest

Cause: Two or more GROUP BY clauses were found in a SELECT
statement. The GROUP BY clause lists column expressions used
to form a summary row for each group of selected rows. The
list can contain several column expressions separated by
commas, but a statement can contain only one GROUP BY clause.

Action: Remove one of the GROUP BY clauses and, if
necessary, separate column expressions by commas.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13224: zero tolerance specified for layer in USER_SDO_GEOM_METADATA

1 Answers  


ORA-02804: Allocation of memory failed for log file name

1 Answers  


QSM-00507: no dimensions could be found

1 Answers  


ORA-22371: Table contains data of type string.string, version string, which does not exist

1 Answers  


ORA-32602: FREEPOOLS and FREELIST GROUPS cannot be used together

1 Answers  






ORA-32150: Cannot perform operation on a null timestamp

1 Answers  


TNS-00202: Failure in redirecting call : Original to string Redirect to string

1 Answers  


ORA-36720: (XSALLOC01) To be used with ALLOCATE, your AGGMAP workspace object must be defined with the ALLOCMAP command.

1 Answers  


SQL-02140: An unnamed connection already exists

1 Answers  


ORA-38760: This database instance failed to turn on flashback database

1 Answers  


DRG-11432: file error while accessing knowledge base

1 Answers  


QSM-01022: a more optimal materialized view than string was used to rewrite

1 Answers  


Categories