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-27144: attempt to kill process failed

1 Answers  


QSM-01533: query rewritten with equivalence, string

1 Answers  


ORA-25453: invalid iterator: string

1 Answers  


ORA-00275: media recovery has already been started

1 Answers  


ORA-30690: timeout occurred while registering a TCP/IP connection for data traffic detection

1 Answers  






DRG-11805: Accepted

1 Answers  


ORA-02349: invalid user-defined type - type is incomplete

1 Answers  


QSM-00780: the task string could not be executed because the workload string is being modified

1 Answers  


ORA-32333: disable table scn update for Materialized view

1 Answers  


RMAN-06179: datafile number not processed because file is read-only

1 Answers  


NNL-00280: No restart currently scheduled

1 Answers  


NCR-01010: NCRS: Invalid network address length.

1 Answers  


Categories