QSM-02003: aggregate function nested within an expression

Question Posted / guest

1 Answers
3106 Views
I also Faced
E-Mail Answers

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

NID-00500: Keyword Description (Default)

1 Answers

ORA-37043: (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.

1 Answers

TNS-00247: Unable to allocate memory for configuration data from TNSNET.ORA file

1 Answers

NNO-00111: line string: data type "string" has syntax "string", should be "string", data ignored

1 Answers

RMAN-06513: copy will never be obsolete

1 Answers

ORA-31082: invalid attribute "string" specified in declaration of "string"

1 Answers

DRG-50859: failed to allocate statement handle

1 Answers

ORA-34286: (MXDCL53) workspace object cannot be used in this context because it is a string.