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...


ORA-30486: invalid window aggregation group in the window
specification



ORA-30486: invalid window aggregation group in the window specification..

Answer / guest

Cause: If the window specification is specified using RANGE
option and there are multiple ORDER BY expressions, then the
aggregation group cannot contain any expression (It can only
have CURRENT ROW, UNBOUNDED PRECEDING, or UNBOUNDED
FOLLOWING). First end point (bound) cannot be UNBOUNDED
FOLLOWING and second end point cannot be UNBOUNDED
PRECEDING. If the first end point is CURRENT ROW, then
second end point can only be CURRENT ROW or <expr>
/UNBOUNDED FOLLOWING. If the first end point is <expr>
FOLLOWING, then second end point can only be
<expr>/UNBOUNDED FOLLOWING.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-00778: the specified output filename string is invalid or cannot be accessed

1 Answers  


QSM-01123: self-join algorithm could not resolve multiple instances

1 Answers  


ORA-00073: command string takes between string and string argument(s)

1 Answers  


ORA-26004: Tables loaded through the direct path may not be clustered

1 Answers  


SQL*Loader-00919: Error during upi fetch: [number]

1 Answers  


ORA-06302: IPA: Cannot connect to remote host

1 Answers  


TNS-12229: TNS:Interchange has no more free connections

1 Answers  


LPX-00303: attribute value "~S" not expected for ~S

1 Answers  


TNS-12201: TNS:encountered too small a connection buffer

1 Answers  


ORA-31222: DBMS_LDAP: PL/SQL - Invalid LDAP SSL authentication mode.

1 Answers  


ORA-12491: DBHIGH value does not dominate DBLOW

1 Answers  


ORA-29966: The only binding of an operator cannot be dropped

1 Answers  


Categories