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-38492: invalid ALTER INDEX parameters clause "string"

1 Answers  


PCC-02129: CMD-LINE: Client supplied static options table is invalid

1 Answers  


NNL-00810: Queries received with no type: number

1 Answers  


PLS-00438: value in LIMIT clause: 'string' use is invalid

1 Answers  


KUP-03021: clause references unknown field string

1 Answers  


ORA-25118: invalid DUMP DATAFILE/TEMPFILE option

1 Answers  


ORA-00750: database has been previously mounted and dismounted

2 Answers  


NNO-00305: trace level changed from number to number

1 Answers  


ORA-12481: effective label not within program unit clearance range

1 Answers  


ORA-01984: invalid auditing option for procedures/packages/functions

1 Answers  


TNS-12676: Server received internal error from client

1 Answers  


ORA-14458: attempt was made to create a temporary table with INDEX organization

1 Answers  


Categories