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-06608: LU6.2 Driver: Reset occurred in receive state

1 Answers  


ORA-22278: must update the LOB only through the LOB buffers

1 Answers  


QSM-00763: the owner string is invalid while validating user-defined workload string.string

1 Answers  


ORA-16186: Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier

1 Answers  


TNS-12536: TNS:operation would block

1 Answers  






LSX-00214: too many occurrences of particle "~1S", maximum is ~2d

1 Answers  


ORA-00274: illegal recovery option string

1 Answers  


DRG-51030: wildcard query expansion resulted in too many terms

1 Answers  


ORA-01487: packed decimal number too large for supplied buffer

1 Answers  


SQL*Loader-00429: insufficient number of elements found for varray

1 Answers  


ORA-19592: wrong string conversation type

1 Answers  


ORA-39098: Worker process received data objects while loading metadata. Invalid process order range is string..string

1 Answers  


Categories