Query Errors 'ORA-00979: Not A GROUP BY Expression' in 12.2 but Works in 11.2
(Doc ID 2475227.1)
Last updated on MARCH 28, 2019
Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
- GROUP BY clause with nvl() produces ORA-00979 in Oracle 12.2 environment while same sql runs without error in 220.127.116.11
- Removing the NVL function from the group by expression makes the query run as expected on both versions 18.104.22.168 and 22.214.171.124
Upgraded from 126.96.36.199 to 12.2.
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.