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-02135: agg(expr) requires correspondng AVG(expr) function



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

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

PLS-00257: illegal use of EXTERNAL clause in a TYPE or PACKAGE specification

1 Answers  


AUD-00703: unable to read audio data

1 Answers  


RMAN-03018: asynchronous RPCs are working correctly

1 Answers  


NID-00110: Cannot use REVERT and specify a database name at the same time

1 Answers  


RMAN-06163: some datafiles cannot be recovered, aborting the RECOVER command

1 Answers  


ORA-32018: parameter cannot be modified in memory on another instance

1 Answers  


TNS-00205: Turning off tracing in intlsnr

1 Answers  


ORA-16782: some instance not open for read and write access

1 Answers  


ORA-14625: subpartition contains rows corresponding to values being dropped

1 Answers  


ORA-38425: attribute set used for an index object may not be unassigned

1 Answers  


IMP-00016: required character set conversion (type number to number) not supported

1 Answers  


NZE-29037: No certificate is present

1 Answers  


Categories