QSM-02104: aggregate function in a filter condition in the
HAVING clause



QSM-02104: aggregate function in a filter condition in the HAVING clause..

Answer / guest

Cause: The capability in question is not supported when the
materialized view references an aggregate function in a
filter condition in the HAVING clause.

Action: Re-phrase the query to avoid the use of aggregates
in filter conditions in the HAVING clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-00010: Statement out of place at line number in file string

1 Answers  


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

1 Answers  


SQL-02125: Connect error, can't get error text

1 Answers  


ORA-30340: illegal dimension name

1 Answers  


ORA-12618: TNS:versions are incompatible

1 Answers  






ORA-24023: Internal error in DBMS_AQ_EXP_INTERNAL.string [string] [string]

1 Answers  


O2F-00304: Invalid filename for the INTYPE file

1 Answers  


ORA-00385: cannot enable Very Large Memory with new buffer cache parameters

1 Answers  


ORA-14622: Value string already exists in subpartition string

1 Answers  


ORA-25181: missing ON keyword for NESTED INDEX

1 Answers  


PLS-00629: PIPE statement cannot be used in non-pipelined functions

1 Answers  


ORA-12640: Authentication adapter initialization failed

1 Answers  


Categories