Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-31016: Attempted to delete entry without name

1 Answers  


TNS-01184: Listener rejected registration or update of service handler "string"

1 Answers  


ORA-13141: invalid RANGE window definition

1 Answers  


AMD-00144: Custom Measure "string" does not exist in Workspace "string"

1 Answers  


NZE-28821: No input buffer provided.

1 Answers  






NZE-29224: Cannot locate matching certificate request.

1 Answers  


TNS-01170: Event detection broke for address: string

1 Answers  


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

1 Answers  


NCR-01005: NCRS: Failed to flush the output buffer.

1 Answers  


DRG-12602: index owner does not have access to user datastore procedure: string

1 Answers  


ORA-13773: insufficient privileges to select data from the cursor cache

1 Answers  


SQL*Loader-00905: Error parsing SQL statement for upi: [number]

1 Answers  






Categories