Oracle DBA, How To, Error, Cause and Action

ORA-00962: too many group-by / order-by expressions

ORA-00962: too many group-by / order-by expressions



Cause: The group-by or order-by column list contain more than 1000 expressions.



Action: Use 1000 or less expressions in the group-by or order-by list.