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

TNS-01108: Listener password prompt failed

1 Answers  


O2I-00129: No Java file specified

1 Answers  


LCD-00203: missing keyword [string]

1 Answers  


ORA-02225: only EXECUTE and DEBUG privileges are valid for procedures

1 Answers  


ORA-16625: cannot reach the primary

1 Answers  


PLS-00728: the limit of a VARRAY can only be increased and to a maximum 2147483647

1 Answers  


IMG-00003: exhausted memory while processing image

1 Answers  


ORA-24049: invalid agent name string, names with AQ$_ prefix are not valid

1 Answers  


ORA-12551: TNS:missing keyword

1 Answers  


DRG-11856: FTP Server Doesn't Reply

1 Answers  


ORA-38730: Invalid SCN/TIMESTAMP expression.

1 Answers  


ORA-04082: NEW or OLD references not allowed in table level triggers

2 Answers   Satyam,


Categories