QSM-02136: agg(expr) requires correspondng VARIANCE(expr) function

QSM-02136: agg(expr) requires correspondng VARIANCE(expr)
function

Question Posted / guest

1 Answers
1491 Views
I also Faced
E-Mail Answers

QSM-02136: agg(expr) requires correspondng VARIANCE(expr) function..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses certain aggregate functions but omits
an invocation of the VARIANCE function on the same argument.

Action: Add the VARIANCE function to the select list.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

PCB-00012: Command line option DYNAMIC=ANSI required with option TYPE_CODE=ANSI

1 Answers

RMAN-06740: database name is not specified

1 Answers

PCC-02319: expression type does not match usage

1 Answers

ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

1 Answers

ORA-02435: cannot disable unique(string) - unique key not defined for table

1 Answers

ORA-00052: maximum number of enqueue resources (string) exceeded

1 Answers

ORA-07254: spdcr: translation error while expanding ?/bin/oracle.

1 Answers

DRG-10000: failed to read column string.string

1 Answers

ORA-32838: exceeded maximum number of properties

1 Answers

ORA-01771: illegal option for a clustered table