How to fix the Oracle error ORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list?

In this post, you’ll learn more about the Oracle ErrorORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list

Reason for the Error ORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list

An expression in the GROUP BY ROLLUP or CUBE list matches an expression in the ordinary GROUP BY expression list

How to fix the Error ORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list ?

You can fix this error in Oracle by following the below steps

Remove the expression from either ordinary GROUP BY expression list or ROLLUP or CUBE expression list