Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

RMAN-00554: initialization of internal recovery manager package failed

1 Answers  


RMAN-20034: resync not needed

1 Answers  


NNL-00261: Request forwarding is currently enabled

1 Answers  


NCR-01012: NCRS: Receive message failure.

1 Answers  


TNS-00541: underlying transport does not exist.

1 Answers  


ORA-01010: invalid OCI operation

1 Answers  


ORA-19768: USING clause only valid with ENABLE CHANGE TRACKING

1 Answers  


ORA-31001: Invalid resource handle or path name "string"

1 Answers  


KUP-04067: internal error allocating handle type string

1 Answers  


ORA-02808: Allocation of memory of open files array failed.

1 Answers  


NID-00336: The following datafiles are offline clean:

1 Answers  


ORA-12454: label string does not exist for policy string

1 Answers  


Categories