QSM-02003: aggregate function nested within an expression



QSM-02003: aggregate function nested within an expression..

Answer / guest

Cause: The capability in question is not supported when the
materialized view contains an aggregate function invocation
nested within an outer expression.

Action: Re-phrase the expression such that the aggregate
function invocation is not nested.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

UDE-00005: unexpected End-Of-File encountered while reading input

1 Answers  


EXP-00077: multiple output files specified for unbounded export file

1 Answers  


ORA-16195: DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined

1 Answers  


TNS-12223: TNS:internal limit restriction exceeded

1 Answers  


KUP-03001: fatal error during library cache pre-loading

1 Answers  






PLS-00245: Formals used in the 'parameters' clause must appear exactly once

1 Answers  


NID-00303: Datafile string - wrote new name

1 Answers  


PCC-02346: PL/SQL found semantic errors

1 Answers  


ORA-13415: invalid or out of scope point specification

1 Answers  


CLSS-00004: unable to allocate memory resources

1 Answers  


EXP-00103: The FLASHBACK_TIME parameter was invalid

1 Answers  


DRG-52105: no delete function found

1 Answers  


Categories