ORA-00979: Not A GROUP BY Expression from INSERT INTO ... SELECT, even Fix for 27574891 Applied
(Doc ID 2804026.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 18.14.0.0.0 [Release 12.1 to 18]Information in this document applies to any platform.
Symptoms
During an INSERT INTO ... SELECT statement, you receive error
ORA-00979: not a GROUP BY expression
If the SELECT portion is executed alone, then the error does not occur.
Applying the fix for non-published Bug 27574891 did not help.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |