QSM-02014: GROUP BY expression other than a column



QSM-02014: GROUP BY expression other than a column..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses an expression other than a simple
column reference in the GROUP BY clause.

Action: Re-phrase the query to use only simple column
expressions in 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

LPX-00246: missing system ID after public ID

1 Answers  


PLS-00522: MAP methods must return a scalar type.

1 Answers  


ORA-31157: Invalid Content-Type charset

1 Answers  


TNS-04008: %-25s | string

1 Answers  


TNS-12671: Shared server: adapter failed to save context

1 Answers  






ORA-02245: invalid ROLLBACK SEGMENT name

1 Answers  


PLS-00462: nested subprogram 'string' has to be REPEATABLE

1 Answers  


RMAN-12010: automatic channel allocation initialization failed

1 Answers  


TNS-12155: TNS:received bad datatype in NSWMARKER packet

1 Answers  


TNS-00230: Cannot start new pump process: string string Protocol Adapter errors:number

1 Answers  


ORA-01145: offline immediate disallowed unless media recovery enabled

1 Answers  


ORA-22297: warning: Open LOBs exist at transaction commit time

1 Answers  


Categories