256 Kilobytes

Answers in Databases | By Some Guy


390 views, 0 RAMs, and 1 comment

Tags: SQL, Errors, Oracle, Programming

Profile Photo - Some GuySome GuyBasic Subscriber

How may i get this solved on oracle programming. I am not new to this language but the error seems strange. ORA-00979: not a group by expression. Any opinion is welcomed.

Download more RAM. 🐏 ⨉ 0Posted by Some Guy 2 years ago 🕓 Posted at 16 December, 2018 09:28 AM PST

This is a debug account.

Profile Photo - Hash BrownHash BrownInternet ActivistEnglandStaff


ORA-009779 is a fairly straight forward error. You have not included any code so I'll have to explain what it's likely to be...

It's usually best to do one of the following things to fix this error:

  1. Remove expressions that don't belong in the GROUP BY clause from the SELECT list
  2. Try removing the GROUP BY function from the SELECT command
  3. Rewriting the SELECT statement, so the column listed in the SELECT statement is added to the GROUP BY clause.

You can avoid this error by simply including expressions are listed in both the SELECT statement and the GROUP BY clause. If the expression is already in the GROUP BY clause then you should not see this error, you may want to contact your database Admin.

Download more RAM. 🐏 ⨉ 0Posted by Hash Brown 2 years ago 🕓 Posted at 19 December, 2018 08:36 AM PST


Post a New Comment

Do you like having a good time?

Register an Account

You can also login to an existing account or reset your password. All use of this site is subject to the terms of service and privacy policy.

Read Quality Articles

Read some quality articles. If you can manage to not get banned for like five minutes, you can even post your own articles.

View Articles →

Argue with People on the Internet

Use your account to explain why people are wrong on the Internet forum.

View Forum →

Vandalize the Wiki

Or don't. I'm not your dad.

View Wiki →

Ask and/or Answer Questions

If someone asks a terrible question, post a LMGTFY link.

View Answers →

Make Some Money

Hire freelancers and/or advertise your goods and/or services. Hire people directly. We're not a middleman or your dad. Manage your own business transactions.

Register an Account

Answers— Read More

Find more related content below!