OraFAQ Forum: SQL & PL/SQL » ORA-00979: not a GROUP BY expression
In this case you have to provide a
You have to provide the complete version numbers also for your 18c version (query v$version and/or provide the db message when you connect with SQL*Plus).
In this case you have to provide a test case : CREATE TABLE and INSERT statements for some data so we can reproduce what you have in different versions to know if it is a bug in one of these versions.You have to provide the complete version numbers also for your 18c version (query v$version and/or provide the db message when you connect with SQL*Plus).
Report message to a moderator
