QSM-02137: agg(expr) requires correspondng STDDEV(expr) function



QSM-02137: agg(expr) requires correspondng STDDEV(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 STDDEV function on the same argument.

Action: Add the STDDEV 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

ORA-09840: soacon: Name translation failure.

1 Answers  


PLS-00606: cursor subquery is not supported on client side in this release

1 Answers  


DRG-10707: a value is required for attribute string of preference string

1 Answers  


PCC-02373: Invalid declaration in EXEC SQL DECLARE section

1 Answers  


ORA-12831: Must COMMIT or ROLLBACK after executing INSERT with APPEND hint

1 Answers  






ORA-02175: invalid rollback segment name

1 Answers  


SQL*Loader-00407: If data is all generated, number to skip is meaningless

1 Answers  


ORA-09273: szrfc: error verifying role name

1 Answers  


ORA-15043: ASM disk "string" is not a diskgroup member

1 Answers  


ORA-09834: snyGetPortSet: failed to collect info on a port.

1 Answers  


NZE-28764: failure to retrieve a configuration parameter

1 Answers  


PLS-00313: 'string' not declared in this scope

1 Answers  


Categories