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

ORA-19904: test recovery not allowed for datafile string

1 Answers  


KUP-04004: error while reading file string

1 Answers  


ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

1 Answers  


ORA-27502: IPC error deleting OSD context

1 Answers  


ORA-06111: NETTCP: disconnect failure

1 Answers  


ORA-25192: invalid option for an index-organized table

1 Answers  


ORA-07591: spdde: $GETJPIW failure

1 Answers  


ORA-06533: Subscript beyond count

1 Answers  


ORA-01903: EVENTS keyword expected

1 Answers  


ORA-01144: File size (string blocks) exceeds maximum of string blocks

2 Answers  


ORA-15040: diskgroup is incomplete

1 Answers  


ORA-01298: conflicting dictionary option

1 Answers  


Categories