ora-00979 not a GROUP BY expression

You must put all columns of the SELECT in the GROUP BY or use functions on them which compress the results to a single value (like MIN, MAX or SUM).

http://stackoverflow.com/questions/1520608/ora-00979-not-a-group-by-expression