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

ORA-23620: bind value size too large for PL/SQL CALL operation

1 Answers  


RMAN-12007: cannot allocate more than number channels

1 Answers  


ORA-34901: (PPWKDAYS01) Blank lines are not allowed in the DAYNAMES option.

1 Answers  


ORA-14096: tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns

1 Answers  


ORA-02033: a cluster index for this cluster already exists

1 Answers  






ORA-12672: Database logon failure

1 Answers  


ORA-16050: destination exceeded specified quota size

1 Answers  


ORA-07716: sksachk: invalid device specification for ARCHIVE

1 Answers  


ORA-02469: Hash expression does not return an Oracle Number.

1 Answers  


PLS-00454: with a returning into clause, the table expression cannot be remote or a subquery

1 Answers  


ORA-24045: invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]

1 Answers  


TNS-00210: Total Pumps Available : number

1 Answers  


Categories