Showing posts with label ORA-30489: Cannot have more than one rollup or cube expression list. Show all posts
Showing posts with label ORA-30489: Cannot have more than one rollup or cube expression list. Show all posts

Tuesday, 22 May 2012

ORA-30489: Cannot have more than one rollup or cube expression list

ORA-30489: Cannot have more than one rollup or cube expression list

Cause: GROUP BY clause has more than one rollup or cube expression list.

Action: Modify the query such that only one rollup or cube expressions appear per sub-query.