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



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

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-01097: Materialized view with grouping sets has too long key

1 Answers  


DRG-11528: LONG or LONG RAW column defintion found in structure data

1 Answers  


PCB-00630: Host variable is not of LOB type

1 Answers  


RMAN-06540: tablespace string will be excluded from future whole database backups

1 Answers  


RMAN-06085: must use SET NEWNAME command to restore datafile string

1 Answers  


NNO-00309: server restarting

1 Answers  


ORA-19621: archivelog range has already been specified

1 Answers  


ORA-07621: smscre: illegal redo block size

1 Answers  


ORA-02780: Name given for the core dump directory is invalid

1 Answers  


ORA-16406: Primary and standby database software version mismatch

1 Answers  


ORA-28044: unsupported directory type

1 Answers  


QSM-00790: the workload string cannot be modified or changed because it is being used by task string

1 Answers  


Categories