QSM-02041: nested aggregate function



QSM-02041: nested aggregate function..

Answer / guest

Cause: The capability in question is not supported when the
materialized view nests an aggregate function invocation as
an argument to another aggregate function.

Action: Re-phrase the query to avoid the nested aggregate
function invocation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23358: invalid remote user

1 Answers  


ORA-33338: (DSSEXIST05) You cannot specify the EXPTEMP analytic workspace.

1 Answers  


IMG-00899: signature cannot be generated

1 Answers  


ORA-01977: Missing thread number

1 Answers  


ORA-13129: HHCODE column string not found

1 Answers  


DRG-50803: failed to define output

1 Answers  


ORA-12463: undefined group string for policy string

1 Answers  


RMAN-08522: input datafile fno=string name=string

1 Answers  


PCC-02442: Expecting a value between 1 and 65535 inclusive

1 Answers  


ORA-27454: argument name and position cannot be NULL

1 Answers  


ORA-16718: failed to locate the database resource

1 Answers  


ORA-30367: a JOIN KEY clause is required

1 Answers  


Categories