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

NNL-00006: timeout, server is not responding

1 Answers  


DRG-11625: MAXURLS * URLSIZE must be less than string

1 Answers  


PCB-00305: Oracle extension to the COMMIT and ROLLBACK statements

1 Answers  


PCB-00204: Group items cannot be used except in INTO or VALUES clause

1 Answers  


ORA-16047: DGID mismatch between destination setting and standby

1 Answers  


ORA-00212: block size string below minimum required size of string bytes

1 Answers  


ORA-29835: ODCIGETINTERFACES routine does not return required interface(s)

1 Answers  


SQL*Loader-00479: REF directive for column string expects number arguments; found number.

1 Answers  


CLSR-06500: Invalid input arguments

1 Answers  


ORA-19627: cannot read backup pieces during controlfile application

1 Answers  


ORA-00364: cannot write header to new log member

1 Answers  


ORA-02007: can't use ALLOCATE or DEALLOCATE options with REBUILD

1 Answers  


Categories