Oracle Error PLS-00602: CUBE and ROLLUP may appear only in a GROUP BY clause

Oracle Error Message

PLS-00602: CUBE and ROLLUP may appear only in a GROUP BY clause

Reason for the Error

User attempted to use the keywords CUBE or ROLLUP outside a GROUP BY clause

Solution

Avoid using the keywords CUBE and ROLLUP outside the GROUP BY clause