ORA-00979: Not A GROUP BY Expression from INSERT INTO ... SELECT, even Fix for 27574891 Applied
(Doc ID 2804026.1)
Last updated on OCTOBER 06, 2021
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199.0 [Release 12.1 to 18]
Information in this document applies to any platform.
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.
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