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-06701: TLI Driver: incorrect number of bytes written

1 Answers  


ORA-29925: cannot execute string

1 Answers  


ORA-13018: bad distance type

1 Answers  


ORA-13509: error encountered during updates to a SWRF table

1 Answers  


ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

1 Answers  






ORA-00329: archived log begins at change string, need change string

1 Answers  


RMAN-06566: target database incarnation not found in control file

1 Answers  


ORA-30075: TIME/TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint

1 Answers  


QSM-01089: an inline view in the query does not have a materialized view

1 Answers  


PROT-00013: Oracle Cluster Registry is in current version

1 Answers  


ORA-12685: Native service required remotely but disabled locally

1 Answers  


ORA-27507: IPC error disconnecting from a port

1 Answers  


Categories